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%'
asked
SQL statement to retrieve names beginning with A or S or 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')
Using a function like this is usually a performance killer because SQL is not able to use an index and you end up with a table or index scan, but LEFT is handled in the same way as LIKE 'C%'
Erm... I have seen many many situations where a LEFT search will beat up a LIKE search, index or not - I think it's one of those 'horses for courses' things. Test, test, test again.
i want names from z and s for my new firm
Hi Try asking a new question rather than resurrecting an old and answered question...
select * from table where name like 'A%' UNION select * from table where name like 'S%' UNION select * from table where name like 'Z%'
select * from table_name where left(name,1) between 'a' and 's' ;
4 People are following this question.
