,<html> All above character should replace wirh space. Below is my query
select empDesc from emp
DECLARE @aText NVARCHAR(100) SET @aText = '<html>i am % a good #@ boy.' SELECT REPLACE(REPLACE(REPLACE(@aText,'#@',''),'%',''),'<html>','')
i am a good boy
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)