Very Computer

I would like to search a varchar(240) column for either a carriage return or
a linefeed. Fulltext is not being used and I was hoping to be able to use
LIKE and  char(xx) with the % wildcard but - no go.
Any suggestions ?

TIA

DB

from bol

Examples
This example, which assumes an ASCII character set, returns the ASCII value and
char character for each character in the string "Du monde entier."

SET TEXTSIZE 0
SET NOCOUNT ON
-- Create the variables for the current character string position
-- and for the character string.

-- Initialize the variables.



   BEGIN



   END
SET NOCOUNT OFF
GO

Quote:-----Original Message-----

I would like to search a varchar(240) column for either a carriage return or
a linefeed. Fulltext is not being used and I was hoping to be able to use
LIKE and  char(xx) with the % wildcard but - no go.
Any suggestions ?

TIA

DB

.

OK, yes I saw that - I thought there might be an alternative but that's ok
for now.
Thanks
DB

from bol

Examples
This example, which assumes an ASCII character set, returns the ASCII value
and
char character for each character in the string "Du monde entier."

SET TEXTSIZE 0
SET NOCOUNT ON
-- Create the variables for the current character string position
-- and for the character string.

-- Initialize the variables.



   BEGIN



   END
SET NOCOUNT OFF
GO

Quote:-----Original Message-----

I would like to search a varchar(240) column for either a carriage return or
a linefeed. Fulltext is not being used and I was hoping to be able to use
LIKE and  char(xx) with the % wildcard but - no go.
Any suggestions ?

TIA

DB

.