[postgis-users] Select statement compare only alpha characters

davidj2k davidj2k at yahoo.com
Thu Mar 20 07:05:10 PDT 2008

I am trying to make a select statement that compares the field to a value
that is only alpha characters so here is the example
This is the value in the database:   $%ABC_abc-123(abc)
This is the value that I want to use to match that value:    abcabcabc

I tried using regexp_replace but it did not work the way I expected.  

select * from table where lower(regexp(fieldname, '[\d_\W]*', '')) =

this regular expression works in C# but not in PostgreSQL

any suggestions
View this message in context: http://www.nabble.com/Select-statement-compare-only-alpha-characters-tp16178846p16178846.html
Sent from the PostGIS - User mailing list archive at Nabble.com.

More information about the postgis-users mailing list