Beginning with a #

[sinewaves]

I want to have a number of links where you click on the letter and get all the records starting with that letter...no problem, but how do i get all the records that start with a number?
any help would be great

[The Hobo]

Maybe I'm not following here, but, the substr function to get the first character and then compare to the link text?

Maybe if you could explain a little more about the problem. I think I understand the scenario well enough.

[sinewaves]

oh sorry....

basically it's a big list of bands, but some of them start with a number.

How would i do a SELECT * FROM TABLENAME WHERE the first character isnumeric?

[chrisjk]

for the letter ones, use something like

SELECT * FROM table WHERE SUBSTRING(fieldname, 1, 1) = 'A'

for numbers, I think this will do

SELECT * FROM table WHERE SUBSTRING(fieldname, 1, 1) BETWEEN 0 AND 9