MPardo
Jun 22nd, 2000, 10:55 PM
Hi,
I am trying to query an Oracle db for some records. I need the query to only return records where the first letter in a field is numeric. Although I don't get an error when I try using the "WHERE ca_id NOT LIKE '[A-Za-z]'", it still returns records with letters as the first character. Is there a way to designate ranges in a SQL statement for Oracle?
Thanks.
Matt
I am trying to query an Oracle db for some records. I need the query to only return records where the first letter in a field is numeric. Although I don't get an error when I try using the "WHERE ca_id NOT LIKE '[A-Za-z]'", it still returns records with letters as the first character. Is there a way to designate ranges in a SQL statement for Oracle?
Thanks.
Matt