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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER