Tsql string replace function

select replace(replace(‘string1+usa — string2+ canada’,‘USA’,),‘canada’,)

┬áselect replace(replace(COLUMN_NAME,‘USA’,),‘canada’,)

 

Leave a Reply

Your email address will not be published. Required fields are marked *