SQL Server Replace Syntax for replacing text string with syntax
Posted on 2011-09-27
I'm trying the following - basically just trying to remove any occurrence of that '; ;' and replace it with blank or nothing. What am I missing in the syntax? Every time I run this, it just wipes the whole extended_desc field and makes the whole field null, rather than just wiping out those three characters...
SET extended_desc = replace(extended_desc,'; ;','')
WHERE extended_desc LIKE '%; ;%'