Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 518
  • Last Modified:

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
0
RHADMIN
Asked:
RHADMIN
1 Solution
 
chapmandewCommented:
SELECT Comment
FROM Forum
WHERE charindex(CHAR(13), Comment) > 0
0
 
RHADMINAuthor Commented:
This is QUICK and get to the POINT! Thanks:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now