a query issue
Posted: Wed Feb 14, 2007 4:49 am
my table has 2 columns id and name
i want to select all those names that start with a number [0-9] using a query is this possible?
for example for selecting all the names starting with A i am doing this:
I need help to select name starting with number like "100 5 The Zones Acoustic Xmas" etc
thank you
i want to select all those names that start with a number [0-9] using a query is this possible?
for example for selecting all the names starting with A i am doing this:
Code: Select all
name LIKE 'A%'thank you