Remove spaces between words

Posted by Rajnilari2015 under Sql Server category on | Points: 40 | Views : 204
Suppose we have input as : "This is RNA Team"

The desire output should be : "ThisisRNATeam"

SQL Query

declare @str as varchar(100)
set @str = 'This is RNA Team' -- original data
select REPLACE(@str,' ' ,'') as RemoveSpace

Comments or Responses

Login to post response