string Space Remove in SQL
Remove space from the string and replace with one space.
DECLARE @String NVARCHAR(50)
SET @String ="Chirag is Test"
select replace(replace(replace(@String," ","<>"),"><",""),"<>"," ")
1