use "where [field] like [a-z]" with Oracle 9i
Posted on 2004-09-16
I have a problem here with Oracle 9i. I have a sql statement using mysql but I don't know how to convert this statement to Oracle.
MySQL: select * from [table] where [column] NOT REGEXP '^[a-z]'
Which means i'm selecting all the data from [table] where the [column] first letter does not range between A to Z.
I want to display all the data in my table that [column]'s first letter is not between A to Z.
How would i be able to use this statement i Oracle?
Thanks for your advises!