Beginning with a #

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

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.

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?

for the letter ones, use something like

Code:

---

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

---

for numbers, I think this will do

Code:

---

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

---