watch this  

the official mrchucho blog

SQL Starts with Alpha

Posted 2005 Oct 12
Using SQL (and Oracle), is there an easier way to see if a string (VARCHAR) starts with an alpha?
select id, value
from parameters
where lower(substr(value,0,1)) between 'a' and 'z'

I know that Oracle 10 supports regular expressions, but I’m using Oracle 9.

Responses to "SQL Starts with Alpha"

No responses yet.

Comments are now closed.
atom rss