3 Replies Latest reply on Jul 19, 2006 6:59 AM by drforbin1970

    Unusual Database Query

    silstorm Level 1
      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'


      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!