Lazzycoder Code For Everyone

Have a Question?

If you have any question you can ask below or enter what you are looking for!

    Find records containing a string in MSSQL

    29-12-2015 17:54:18 MSSQL / Basics 0 Bookmark(s) 187 View(s)

     

    The wildcard % stands for one or many characters. 

    SELECT * FROM Customers WHERE LastName LIKE '%ford%';

    If you want to search for customers with a LastName starting with "Ford":

    SELECT * FROM Customers WHERE LastName LIKE 'Ford%';

    And for customers with a LastName ending with "ford":

    SELECT * FROM Customers WHERE LastName LIKE '%ford';