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:138272
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
