LIKE 'a%' ORDER by name
this will result all NAME begin with letter A how to take result of NAME begin with number (0-9)
Thakn you folks
well, your only asking for names beggining with a, but doing a %a% will return any name with an A maybe you can do an or
where (field LIKE '%a' OR field LIKE 0% OR field LIKE '%1' ) ect... could work, i never tried it
