HI WELCOME TO KANSIRIS

UPDATE and REPLACE part of a string in sql server

Leave a Comment
UPDATE mytable
SET Column1 = REPLACE(Column1, N'©', N'Š'),
    Column2 = REPLACE(Column2, N'©', N'Š'),
    Column3 = REPLACE(Column3, N'©', N'Š')

0 comments:

Post a Comment

Note: only a member of this blog may post a comment.