25 December 2013

Replace command in sqlserver

declare @input varchar(200)
  set @input='jc.adi narayana reddy'
 
  select REPLACE(@input,'a','b')


output

jc.bdi nbrbybnb reddy

No comments:

Post a Comment