Like query

I've found all the answer now Let me try if I can help you.

There's called 'Escape character' in SQL Query matching pattern, Like If your character is matching with wildcard charcter then you can escape it.

Now the same problem arises for you that your character '%' is inside a string and you want to match it.

So there's lot of experiment in MSDN[^] reagarding.

Below para is of your solution on linked article.

You can search for character strings that include one or more of the special wildcard characters. For example, the discounts table in a customers database may store discount values that include a percent sign (%). To search for the percent sign as a character instead of as a wildcard character, the ESCAPE keyword and escape character must be provided. For example, a sample database contains a column named comment that contains the text 30%. To search for any rows that contain the string 30% anywhere in the comment column, specify a WHERE clause such as WHERE comment LIKE '%30!%%' ESCAPE '!'. If ESCAPE and the escape character are not specified, the Database Engine returns any rows with the string 30.
If there is no character after an escape character in the LIKE pattern, the pattern is not valid and the LIKE returns FALSE. If the character after an escape character is not a wildcard character, the escape character is discarded and the character following the escape is treated as a regular character in the pattern. This includes the percent sign (%), underscore (_), and left bracket ([) wildcard characters when they are enclosed in double brackets ([ ]). Also, within the double bracket characters ([ ]), escape characters can be used and the caret (^), hyphen (-), and right bracket (]) can be escaped.


Read full article over there you will surely get an answer.

Hello, If you are using SQL Server then see Pattern Matching in Search Conditions[^] look at Searching for Wildcard Characters

How is this..,

TableName : CUSTOMER_MASTER
column name : FIRSTNAME

one row in my table has value "RA%JESH"

Now this is my Query

select * from CUSTOMER_MASTER cm where replace(cm.FIRSTNAME,'%','~') like '%~J%';

Added for Text datatype

select * from CUSTOMER_MASTER cm where replace(convert(varchar,cm.FIRSTNAME),'%','~') like '%~J%'

Let me know if it's helps you

Thanks & regards
Rajesh B

Hi Ismail:rose:

you try the following Code. it will be work well..

SELECT * FROM sp_text WHERE obj_Text LIKE '%'+@keyword +'%'