SELECT starting with non letter
Hello, I'm trying to select all the records whose title does not starts
with a letter.
The query
SELECT * FROM bdoc_entries
WHERE (NOT SUBSTRING(titre,1) IN
('a','b','c','d','e','f','g','h','i','j','k','l',' m','n','o','p','q','r','s','t','u','v','w','x','y' ,'z'))
returns only the records starting with a number but forget the ones
starting with something else (space, quotes, ...)
I don't see why...
Thanks
|