The following query (modified from original to make it easier for you to
read) select all of the clients whose fisrt initial of their last name
equals a specified character ($lastInitial). It works fine for characters
A-Z but I need to know what to set $lastInitial to for it to select clients
last names that start with a different character than A-Z such as a number
or some kind of punctuation.
select * from Clients
where left(lastName,1) = $lastInitial
order by lastName ASC
Thank you in advance
Jeremy Shovan