I am trying to find a way to select any record that begins with numbers meaning
0-infinity.

I thought using between, but i would have to set the range, but would rather have it just see its a numeral and act accordingly.

Rich

select foo from bar where qux regex '^[0-9]'

OK,
How could i use this with my current select which is selecting anything LIKE $letter%.

I would like it to Select titles with either numbers or letters but not both.
Example:

SELECT * FROM movies WHERE title LIKE $letter% OR title LIKE regex [0-9]

This isnt the correct code, because I am not sure how to implement.
Thanks
Rich

could you please give some examples of titles that do not satisfy these criteria (either numbers or letters)

titles that begin with any letter of the alphabet:

An American Werewolf in London
The Thing
Salo

Any title that begins with numerals like:
500 Blows
1,001 ways to kill a cat

if you go to http://www.rareoopdvds.com/listing.php?letter=e
you will see what I am actually doing.

Thanks
Rich

okay, i understand titles starting with letters

and i understand titles starting with numbers

what i was interested in seeing examples of was titles that satisfied what you said earlier - "I would like it to Select titles with either numbers or letters but not both"

titles that start with letters --titles that start with numbers --titles that start with neither a letter nor a number --