Posted on 2012-04-12
I am trying to replace any "<br>" that is returned from my query. Can someone help me with the replace function because it doesn't seem that I have it correct.....
where homeownerNames Like '%<br>%'
or agentNotes Like '%<br>%'
or notes Like '%<br>%'
The update that I am trying to use but breaks is....
SET homeownerNames = REPLACE(homeownerNames, '<br>', ' ')
WHERE id = #id#
Can someone tell me what I am doing wrong.