string Space Remove in SQL
Remove space from the string and replace with one space.
DECLARE @String NVARCHAR(50);
SET @String = "Chirag is here";
SELECT REPLACE(REPLACE(REPLACE(@String, " ", "<>"), "><", ""), "<>", " ");
Blog Details
Chirag Patel
As a CEO with a passion for software innovation, I bridge the gap between visionary leadership and hands-on technical expertise. I thrive on designing and delivering cutting-edge solutions while driving my company forward with a deep understanding of software development.