Distinct Substring Query

[arfinator]

Hello,

I have a large list of songs and artists and I am creating a playlist. At the top, I have the user select a letter which will then direct them to artists that start with that letter.

The problem I am running into is for artists that start with a number should be going under a separate category 0-9 and '. But instead they are going as individual numbers in the list.

The query I am running for this is:

SELECT distinct substr(artist, 1,1) as browse FROM songlist WHERE songtype = "S" or songtype = "C" ORDER by artist asc

I have tried adding into the where clause AND songlist.browse not like '1%') etc.

My question is, can I run a query and exclude numbers from returning in the result?

Does anyone have any suggestions that I could use to accomplish this?

Thank you in advance to anyone who may be of help.

Hess Smith

[flann]

Originally Posted by arfinator

My question is, can I run a query and exclude numbers from returning in the result?

where field <> whatever