How to search wildcards character in string

No.of Views	:	1110
Bookmarked	:	0 times
Downloads	:
Votes	:	0

By youngmurukan On 15 Feb 2010 21:02:15

Tag : Sql Servers , T-SQL

Skill Level: Intermediate

Images in this article missing? We recently lost them in a site migration. We're working to restore these as you read this. Should you need an image in an emergency, please contact us at info@codegain.com

If you need to search for actual underscore or percent characters in a string, you can use the
ESCAPE option to identify those characters.
For example,

'%\%%' ESCAPE '\'

The character after the ESCAPE tells the database how to differentiate between characters to
search for and wildcards, and in the example the backslash character (\) is used.
The first % is treated as a wildcard and matches any number of characters;
the second % is treated as an actual character to search for;
the third % is treated as a wildcard and matches any number of characters.

The following query uses the promotions table, which contains the details for products being
discounted by the store .
The query uses the LIKE operator to search the name column of the promotions table for the values whatever starts or ends with '%' character.

SELECT name
FROM promotions
WHERE name LIKE '%\%%' ESCAPE '\';

The results would be as shown below,

NAME
------------------------------
10% off Z Files
20% off Pop 3
30% off Modern Science

About Author

youngmurukan

Occupation	-	Not Provided
Company	-	Not Provided
Member Type	-	Senior
Location	-	Not Provided
Joined date	-	12 May 2009
Home Page	-	Not Provided
Blog Page	-	Not Provided


Other popularSectionarticles
Use of Rank() function in SQL Server Use of Rank() function in SQL Server Published Date : 15/Feb/2010 Use of Dense_Rank() function in SQL Server Use of Dense_Rank() function in SQL Server Published Date : 15/Feb/2010 How to Get First,Last and No of Days in Month Using T-Sql I have read few questions in forums, about how to select first, last date month and how many days in a month. In my project had used some query to perform these tasks. I will share those with article. Published Date : 17/Dec/2010 How to select random records in SQl Server How to select random records in SQl Server Published Date : 15/Feb/2010 how to get how many records entered in day by a user in sql server. how to get how many records entered in day by a user in sql server. Published Date : 15/Feb/2010

Comments

There is no comments for this articles.