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?
<pre><code> select id, value from parameters where lower(substr(value,0,1)) between 'a' and 'z' </code>
I know that Oracle 10 supports regular expressions, but I’m using Oracle 9.