Thanks, I'll give that a try. Regards,
Howie ----- Original Message ----- From: "Jason Lees (National Express)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 24, 2003 9:35 AM Subject: RE: SQL regex select > Yes, in MSSQL > > Select > * > from > myTable > where > myColumn like '[a-z]iger' > > so you can build up regular expresions like that, > > Jason Lees > Development Team Leader > National Express. > > > -----Original Message----- > From: Howie Hamlin [mailto:[EMAIL PROTECTED] > Sent: 24 September 2003 14:27 > To: CF-Talk > Subject: SQL regex select > > > 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 > > Is this possible? > > Thanks, > > Howie > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138276 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
