I am working with SQL server 2008, and facing problem about character replacement.
If I use
SELECT REPLACE(MYWORD,0,1) FROM MYTABLE
MYWORD = "ERMN0"
MYWORD = "ERMN1"
STUFF, which, IMO, ends up being most readable:
DECLARE @MyWORD VARCHAR(20) = 'ABCDEF123' SELECT STUFF(@MyWORD, LEN(@MyWORD), 1, '2')