Quote:Select Replace(@Data,'∞','9999') Data
Quote:Day 9999 - Day 9999
Quote:Day 8 - Day 9999
nvarchar
varchar
DECLARE @Data nvarchar(50) = N'Day 8 - Day ∞'; SELECT Replace(@Data, N'∞', N'9999') As Data; -- Output: Day 8 - Day 9999
N
∞
8
SELECT REPLACE(Data, N'∞', '9999') FROM tmp
Day 8 - Day 9999 Day 4 - Day 9999 Day 2 - Day 9999
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)