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:138273 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 Get the mailserver that powers this list at http://www.coolfusion.com
