On Aug 17, 2007, at 10:58 , Phoenix Kiula wrote:
> What would be the SQL to find data of this nature? My column can only
> have alphanumeric data, and the only symbols allowed are "-" and "_",
> so I tried this regexp query:
>
> select id, t_code
> from traders
> where t_code ~ '[^A-Za-z1-9\-]'
If you're including - in a range as a character, doesn't it have to
go first?
Try this:
WHERE t_code ~ $re$[^-A-Za-z1-9_]$re$
Michael Glaesemann
grzm seespotcode net