Wednesday, August 13, 2008

SQL - Searching by first letter of record example

To search by the first letter of a last name in a table called Contact:

SELECT * FROM CONTACT
WHERE SUBSTRING(LASTNAME, 1, 1) = @SURNAMELETTER
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)