Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to do search on special characters in MS SQL?

Posted on 2008-10-07
2
Medium Priority
?
515 Views
Last Modified: 2010-04-21
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
Comment
Question by:RHADMIN
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 1000 total points
ID: 22664577
SELECT Comment
FROM Forum
WHERE charindex(CHAR(13), Comment) > 0
0
 
LVL 1

Author Closing Comment

by:RHADMIN
ID: 31504046
This is QUICK and get to the POINT! Thanks:)
0

Featured Post

Automating Terraform w Jenkins & AWS CodeCommit

How to configure Jenkins and CodeCommit to allow users to easily create and destroy infrastructure using Terraform code.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question