Re: select field contain chr(10) (Line Feed character) usng T-SQL

From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 10 Feb 2006 22:52:27 +0100

On Thu, 9 Feb 2006 23:03:27 -0800, kei wrote:

How to retrieve all record which has chr(10) in the value of a specific column?

select column1 from table1 where............? (how to write the where
statement)?
Thx!!

Hi kei,

SELECT column1
FROM table1
WHERE CHARINDEX(CHAR(10), column1) <> 0

--
Hugo Kornelis, SQL Server MVP
.

Prev by Date: Re: Datetime Selection II
Next by Date: Re: question on date (or string after using convert function) comparis
Previous by thread: Re: Datetime Selection II
Next by thread: Re: question on date (or string after using convert function) comparis
Index(es):
- Date
- Thread

Relevant Pages

Re: sql query help
... more than 1 date of birth ... FROM Table1 ... Hugo Kornelis, SQL Server MVP ...
(comp.databases.ms-sqlserver)
Re: How to insert auto increment?
... insert into [tablename] (column1) values ... Hugo Kornelis, SQL Server MVP ...
(microsoft.public.sqlserver.mseq)
Re: Joining one to many relational table
... Table1 has A,A,B,B,B and Table2 has A, B. I want to join ... > for B in Table1. ... > For Table1 the values for column1 is A,A,B,B,B and the correspoding values ...
(microsoft.public.cert.exam.mcad)
Re: Joining one to many relational table
... > For Table1 the values for column1 is A,A,B,B,B and the correspoding values ... > as Table2 has 2 rows. ... >>> for B in Table1. ...
(microsoft.public.cert.exam.mcse)
Re: Table compare
... If you want to filter on outer (Table1) criteria, ... "Steve C" wrote in message ... >> Dan Guzman ... >> SQL Server MVP ...
(microsoft.public.sqlserver.programming)