Removing Carriage Returns 1

[edwardturner]

Hi,

Using a SQL statement how can I remove carriage returns from an ntext field? I have tried using the replace function but do not know what to use to denote a carriage return:

update <table>
set <field> = replace(cast(<field> as nvarchar), A, B)

A being a carriage return
B being what I want to replace it with, i.e. nothing.

any ideas or am i going about this the wrong way?

 

[vongrunt]

A = Char(13) + Char(10)
B = ''

?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[edwardturner]

That has worked, cheers for your help.