select query issue
Posted: Fri Dec 08, 2006 4:51 am
need help in query
for example if name is :
Calgary, AB
Opelika, AL
Miami, FL
then it should show
Opelika, AL and Calgary, AB as both start with A
any help.
thanks
Code: Select all
select name form test where name = [first letter is a]Calgary, AB
Opelika, AL
Miami, FL
then it should show
Opelika, AL and Calgary, AB as both start with A
any help.
thanks