Is there any statement like
select * from table where name like (A% , S%, Z%)
or is the below query only the solution
select * from table where name like 'A%' or name like 'S%' or name like 'Z%'
SELECT * FROM table WHERE name LIKE '[ASZ]%'
Edit: In case you have more questions related to LIKE and pattern matching, I just looked up the MSDN link to add here: http://msdn.microsoft.com/en-us/library/ms179859.aspx
Not exactly what you are looking for but may help...
SELECT * FROM [AdventureWorks].[Person].[Contact] c WHERE LEFT (c.FirstName,1) in ('G','M')
4 People are following this question.