selected a field that starts with...

[Phip]

i need this but in a sql format:

SELECT theField FROM tableName WHERE theField starts with the letter A

thanks

[BigDaddy]

http://www.w3schools.com/sql/sql_where.asp


SELECT theField FROM tableName WHERE theField like 'A%'

[Phip]

What if i wanted to select a group like anything that starts with 0 to 9

[whammy]

select * from scripts where title like '1%' OR title like '2%' OR title like '3%' etc.

Assuming that it's not a numeric value... you can do that like:

select * from scripts where cid > 1

[Phip]

That answer is so obvious... I can't believe I didn't think of that. :rolleyes: