Formulas & Functions
1 Topic
BUG in REPLACE FUNCTION?
Hi, I have a very weird issue. We have a requirement to get rid of special Euro language characters. So below replaces Þ with T. However, random letters like H are affected. The below gives GAT as a result. I had a similar issue with S and . Basically unrelated letters are dropped! declare @outStr nvarchar(2000) SET @outStr = 'GATH' SET @outStr = REPLACE(@outStr, 'Þ', 'T') select @outStr ^^^^^^^^ GAT if i replace nvarchar with varchar works ok but we need to preserve any special chars Any ideas what's going on? Thank you, PanosSolved1.2KViews0likes3Comments