[SQL] Reverse pattern match.

2003-08-18 Thread Moonstruck
I want to create a table of regular expression patterns (for assessing phone numbers), something like: CREATE TABLE CallType ( pattern varchar primary key, typevarchar, rateint4); INSERT INTO CallType VALUES ('0[3-9]','Interstate Call

Re: [SQL] Reverse pattern match.

2003-08-20 Thread Moonstruck
Berkus" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Moonstruck, > I want to create a table of regular expression patterns (for assessing > phone numbers), something like: > CREATE TABLE CallType ( pattern varchar primary key, > type