Hey,
I've got this SQL code that works fine for searching a field called "Surname" in a table called "tblCustomer" for
the character "S".
The problem is, that I get all the surnames that contain the "S" character like "Jone(s)" and "A(s)tury" etc.
I just want the surnames that start with "S"
only like "(S)mith" and "(S)tevenson" etc.
Any ideas?
Thanks,
Steve.
I've got this SQL code that works fine for searching a field called "Surname" in a table called "tblCustomer" for
the character "S".
Code:
SELECT * FROM tblCustomer
WHERE Surname LIKE 'S'
ORDER BY Surname;
The problem is, that I get all the surnames that contain the "S" character like "Jone(s)" and "A(s)tury" etc.
I just want the surnames that start with "S"
only like "(S)mith" and "(S)tevenson" etc.
Any ideas?
Thanks,
Steve.