|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Using REPLACEI 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 |
|||||||||||||||||||||||