Replace Single Quotes in SQL SERVER
---------------------------------------------------------------------------------------------------------
@result=how to remove single quote's
REPLACE(@result,char(39),'') (or) REPLACE(@result,char(39),char(39)+char(39))
---------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------
@result=how to remove single quote's
REPLACE(@result,char(39),'') (or) REPLACE(@result,char(39),char(39)+char(39))
---------------------------------------------------------------------------------------------------------
No comments:
Post a Comment