Link to home
Start Free TrialLog in
Avatar of RHADMIN
RHADMIN

asked on

How to do search on special characters in MS SQL?

Hi, Experts,
How I can make following SELECT statement return result set:
(I'm trying to find some special characters like a carriage return(CHAR(13)) in my text field)

SELECT Comment
FROM Forum
WHERE Contains(Comment, CHAR(13))

It seems Full-Text index totally ignores them. Is it possible to make them researchable? and how?

Thanks,
-Rick
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RHADMIN
RHADMIN

ASKER

This is QUICK and get to the POINT! Thanks:)