I need to add a new function to my search facility. At the
moment, users are able to display records alphabetically - they
click on A,B,C etc etc and my query looks for all records that
begin with that letter, like so -
WHERE company_name LIKE '%A'
etc
One thing I don't currently have is the ability for people to
look for anything that begins with a number. I could be lazy and
list numbers 0,1,2,3 etc - but given that there will be few results
anyway, and it looks nicer, I'd like to have the link as '0-9'
So, my question is - how to a perform a query to return all
records that begin with a number?
I'd appreciate any help on this - suffering major brain
freeze on this at the moment!