Using Replace Function

I am using MSDE. In this I have a field that contains a desciption. Prior to saving to the db, I replace all vbcrlf's to <br />'s. That works fine when displaying in HTML, but when I display it in a datagrid, I want to replace the <br />'s with vbcrlf's.





I thought I might be able to do it with a replace function in my SQL query, something like "Select ID, replace(Description, '<br />', vbcrlf) as Description". This produces an error that vbcrlf is not a fieldname. So I tried "select replace(Description, '<br />', 'xxx') as Description", and while this did not create an error, neither was the text replaced.





Am I not using the replace function correctly? Is there another way in which I might accomplish the task?








Dim ConnectionString As String = "server='(local)'; trusted_connection=true; database=dbname"


Dim CommandText As String





'Command text is greatly abreviated for this discussion.


CommandText = "Select ID, replace(Description, '<br />', vbcrlf) as Description"





Dim myConnection As New SqlConnection(ConnectionString)


Dim myCommand As New SqlDataAdapter(CommandText, myConnection)





Dim ds As New DataSet()


Dim dv as new dataview()


myCommand.Fill(ds)





DataGrid1.DataSource = ds


DataGrid1.DataBind()


...


...


...