Thursday, January 29, 2009

Replace Function in SQL Server

eg:-
declare @String varchar(10)
set @string='asd''hu'
select REPLACE(@String,'''','')
Ans:- asdhu

select REPLACE(@String,'sd','ZZ')
Ans:- aZZ'hu