Search % symbol in a column of a table

Below Query will give you all students having % character in their name

select * from Student WHERE CHARINDEX('%',[Student Name],0)>1

Hope this helps

Use [%]

http://stackoverflow.com/questions/7191449/how-do-i-escape-a-percentage-sign-in-t-sql[^]

http://stackoverflow.com/questions/7736956/query-to-find-columns-that-end-with-percent-symbol[^]

try this

select x from users
where columnToBeSearched like '%[%]%' OR
  otherColumnToBeSearched like '%[%]%'

or use this

SELECT * FROM TABLE WHERE COLUMN_NAME LIKE '%[^a-zA-Z0-9]%'

hi

please try this.may It helps you

suppose column contains value as
1234%
11
121
1
and so on...........

and you need to find the value which contain % in that value.
plz try this query


SELECT * FROM tablename WHERE fieldname LIKE ‘%1234[%]%’


plz mark as complete if t helps you

hi

please try this

suppose column contains value as
1234%
11
121
1
and so on...........

and you need to find the value which contain % in that value.
plz try this query


SELECT * FROM tablename WHERE fieldname LIKE ‘%1234[%]%’


plz mark as complete if t helps you