watch this  

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.