Wildcards in SQL Server 2005
The text of this article is not in this database — only its details are. Read it on the old site: Wildcards in SQL Server 2005
3 Comments
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment.
Ton SchliefPosted Mar 1, 2010, 3:50 AM
This is a fine article for anyone who is beginner on SQL Server. There are however some errors in this article. When a selection is wanted for persons living in a Country which ends with "da" (1) or ends with "a" (2) then I would suggest: (1) SELECT * FROM EMPLOYEE WHERE Country LIKE '%da' (2) SELECT * FROM EMPLOYEE WHERE Country LIKE '%a' instead of (1) Country LIKE '%da%' or (2) Country LIKE '%a%' Country UK is obviously not selected with the statement: SELECT * FROM EMPLOYEE WHERE Country LIKE '%a%'
Hieu Ho TrungPosted Nov 3, 2009, 11:39 AM
Excellent
SenthilkumarPosted Oct 30, 2009, 10:14 AM
It will be very useful for write the queries for searching... Good job karthika!!!