Yes, that's what I'm trying to do. This has to do with an idea for email processing via iMS/FusionMail where certain records are required for different users or entire domains. For example, I may want to have a template called for every mail going to coolfusion.com. In my table I would have a rule labeled as [EMAIL PROTECTED] and then any email to that domain would use that rule.
Thanks, Howie ----- Original Message ----- From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 24, 2003 9:38 AM Subject: Re: SQL regex select > Howie Hamlin wrote: > > I have an application where I want to select rows from a table where > > the rows match according to a simple regex. For example, say I have > > the word "tiger" - I would want to select rows with values like: > > > > t* > > * > > ????? > > tiger > > t??er > > So let me get this straight. You have the string in your application, > and you have regex patterns stored in the database, and now you want > to know which patterns match the supplied string? > > BTW, SQL:1999 doesn't do normal regex matchng, so you need to specify > which dialect your RDBMS uses (and * is not a valid regex pattern). > > Jochem > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138275 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm