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

simple query
SELECT/INSERT SELECT performance issue
CASE in a UDF
Query to get a comma separated list of item2 grouped by item1
Help with grouping and selection
CASE in WHERE clause
indexes or indices
varible length of in parameter
joining a temporary ado datatable with database table?
is there a preferred way