As people are suggesting, it works in PostgreSQL, MySQL and in MS SQL only
when you work an object, it's not native to MS SQL..
Taco Fleur
Blog <http://www.tacofleur.com/index/blog/>
http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/
0421 851 786
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
-----Original Message-----
From: Ubqtous [mailto:[EMAIL PROTECTED]
Sent: Saturday, 24 January 2004 5:38 AM
To: CF-Talk
Subject: Re: regex in a query
Tony,
On 1/23/2004 at 14:28, you wrote:
TW> is it possible to use regex in a query?
TW> like I want to find all records in a table that have a field
TW> that matches this string pattern
TW> 1x1x-1x1x-1111-111111-x-xx
TW> where 1x combo is any alphanumeric (4), 1111 numeric (4), 111111 numeric
TW> (6), x alpha (1), xx alpha (2)
TW> can I do it in sql, or should I get all records and parse in cf?
I am pretty sure the SQL approach is DBMS-specific. I know PostgreSQL
offers regex support, but I've not tried it with MSSQL, Access, etc.
~ Ubqtous ~
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
