Search for newline chr

17 Mar 2006 1:34 PM

Craig

Hi,

Could someone tell me how I might search for a newline character in a
particular field?

Many thanks,
Craig

17 Mar 2006 1:42 PM

Aaron Bertrand [SQL Server MVP]

There is carriage return CHAR(13) and linefeed CHAR(10).

So,

SELECT col FROM tbl WHERE CHARINDEX(CHAR(13)+CHAR(10), col) > 0

Show quote

"Craig" <craig_y***@hotmail.com> wrote in message
news:eAtZPecSGHA.1204@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> Could someone tell me how I might search for a newline character in a
> particular field?
>
> Many thanks,
> Craig

17 Mar 2006 1:41 PM

SQL

use char(13) + char(10)

example

declare @v varchar(50)
select @v = 'abc
def'

if @v like '%' + char(13) + char(10) +'%'
print 'yes'

http://sqlservercode.blogspot.com/

17 Mar 2006 1:42 PM

Aaron Bertrand [SQL Server MVP]

There is carriage return CHAR(13) and linefeed CHAR(10).

So,

SELECT col FROM tbl WHERE CHARINDEX(CHAR(13)+CHAR(10), col) > 0

Show quote

"Craig" <craig_y***@hotmail.com> wrote in message
news:eAtZPecSGHA.1204@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> Could someone tell me how I might search for a newline character in a
> particular field?
>
> Many thanks,
> Craig

17 Mar 2006 1:56 PM

Craig

Many thanks, this worked great.

Aaron Bertrand [SQL Server MVP] wrote:
Show quote

> There is carriage return CHAR(13) and linefeed CHAR(10).
>
> So,
>
> SELECT col FROM tbl WHERE CHARINDEX(CHAR(13)+CHAR(10), col) > 0
>
>
>
> "Craig" <craig_y***@hotmail.com> wrote in message
> news:eAtZPecSGHA.1204@TK2MSFTNGP12.phx.gbl...
>
>>Hi,
>>
>>Could someone tell me how I might search for a newline character in a
>>particular field?
>>
>>Many thanks,
>>Craig
>
>
>