MS SQL Server MSEQ - select field contain chr(10) (Line Feed character) usng T-SQL

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

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

kei

2006-02-10, 3:24 am

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!!

Hugo Kornelis

2006-02-10, 8:24 pm

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

Sponsored Links