i have a field called "title" in my table, can you tell me the sql statement to select the row if the first alphabet of the title is "a"?
for example here are 3 rows:
jack is a good boy
jill is sillu
abby is naughty
kevin is lazy
If i do a search on "j" then both jack and jill should come back as results...
and lastly, how to do this if the first character is a number from 0-9?