SELECT * FROM Customers WHERE FirstName LIKE 'J%'

Mar 12, 2010 at 5:43 AM

Hi,

What is the syntax on searching records using like

ex: SELECT *
FROM Customers
WHERE FirstName LIKE 'J%'

 

thanks,

John

Coordinator
Mar 12, 2010 at 4:52 PM
Edited Mar 12, 2010 at 4:55 PM

for any placement

CustomerCollection customerCollection = CustomerCollection.RunSelect(x => x.FirstName.Contains("J"));

for placement at begining of string

CustomerCollection customerCollection = CustomerCollection.RunSelect(x => x.FirstName.StartsWith("J"));

for placement at end of string

CustomerCollection customerCollection = CustomerCollection.RunSelect(x => x.FirstName.EndsWith("J"));