<div>
Hi andrewst<br />
<br />
Your solution LOWER(SUBSTR(column,1,1)) NOT BETWEEN 'a' AND 'z' worked for me, thanks!<br />
But I like to know how this code works, can you give me a brief explaination before I accept your answer? Thanks a lot! XD
</div>


Hi andrewst

Your solution LOWER(SUBSTR(column,1,1)) NOT BETWEEN 'a' AND 'z' worked for me, thanks!
But I like to know how this code works, can you give me a brief explaination before I accept your answer? Thanks a lot! XD

<div>
SUBSTR(column,1,1) returns the substring of the string in column, starting at position 1 and with length 1. &nbsp;So if the string was 'ABC' then it would return 'A'. <br />
LOWER returns the string after changing any uppercase letters in it to lowercase. &nbsp;So if the straing was 'Ab123cD!' it would return 'ab123cd!'<br />
Finally, NOT BETWEEN 'a' AND 'z' compares the single character returned by LOWER(SUBSTR(column,1,1)) with the range 'a' to 'z' inclusive.
</div>


SUBSTR(column,1,1) returns the substring of the string in column, starting at position 1 and with length 1.  So if the string was 'ABC' then it would return 'A'.
LOWER returns the string after changing any uppercase letters in it to lowercase.  So if the straing was 'Ab123cD!' it would return 'ab123cd!'
Finally, NOT BETWEEN 'a' AND 'z' compares the single character returned by LOWER(SUBSTR(column,1,1)) with the range 'a' to 'z' inclusive.

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
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.<br />
<br />
MySQL: select * from [table] where [column] NOT REGEXP '^[a-z]'<br />
<br />
Which means i'm selecting all the data from [table] where the [column] first letter does not range between A to Z.<br />
I want to display all the data in my table that [column]'s first letter is not between A to Z.<br />
How would i be able to use this statement i Oracle?<br />
Thanks for your advises!<br />
<br />
Jimbo<br />

</div>
</div>


Hi Experts,

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!

Jimbo


use &quot;where [field] like [a-z]&quot; with Oracle 9i

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

use &quot;where [field] like [a-z]&quot; with Oracle 9i

use "where [field] like [a-z]" with Oracle 9i