Query fields that start with a number

[TheDust]

I am building an index for our Client List page, which lists over 400 clients of ours. I want to change the SELECT query that returns the resultset that is shown to select ONLY records that start with a certain letter. This is being done with the addition of the following code to my MySQL query:

$query_Clients .= "WHERE clientName LIKE '".$_GET['letter']."%' ";

However, I'm having trouble finding information on how to constrain results to entries where clientName starts with a numerical value. Has anyone ever encountered this problem?

 

[r937]

i don't see that it's a problem

if the value of letter is a digit, the query will still work as intended

rudy

http://r937.com/

SQL Consulting