In SQL Server how to replace character. [Resolved]

Posted by Karthik2010_Mca under Interview Questions on 2/24/2013 | Points: 10 | Views : 1156 | Status : [Member] | Replies : 1
Hi,
In SQL Server how to replace character. Like below scenario,

Ex,
DECLARE @Name VARCHAR(50)
SET @Name = "WELCOME"
How to replace of 'O' insert 'AA'

Output,
WELCAAME

Thanks
Karthik

Karthik


Responses

Posted by: Murugavelmsc on: 2/24/2013 [Member] Starter | Points: 50

Up
0
Down

Resolved
SELECT REPLACE(@Name,'O','AA')

Regards,
Murugavel S
murugavel.sadagopan@gmail.com
http://murugavelmsc.blogspot.in/

Karthik2010_Mca, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response