Using REPLACE

microsoft.public.sqlserver.programming

13 Dec 2006 1:12 AM

David C

I am trying to use a REPLACE function to replace '<br />' in a text field
with CHAR(13) but it fails and I'm not sure why. My statement is

REPLACE(activity_note, '<br />', CHAR(13))

The activity_note is a text column and I want to be able to replace HTML
line breaks in this field with carriage returns in an SQL view. Can anyone
help? Thanks.

David