How do you select all results starting with a #?

[TheDust]

Well, the question pretty much sums it up... of course I can get results starting with any given letter using:

"LIKE 'r%'" or whatever... but how do I fetch all results that don't start with a letter??

Could anyone offer some advice here? Thanks...
Dust

 

[swampBoogie]

where substring(c from 1 for 1) not between 'A' and 'Z'
and substring(c from 1 for 1) not between 'a' and 'z'

 

[sleipnir214]

WHERE thefield REGEXP '^[^A-Za-z]'

for rows where the field doesn't start with a letter at all.

WHERE thefield REGEXP '^[^r]'

for rows where the field does not start with the letter lowercase r Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!