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]
