Blank space

Hi I am trying to remove the space between the words to make it one single
word.
ETK SETTLEM ESCROW ACCOUNT
I used this command: REPLACE(String,' ','')
Thank you for any helpHi,
This should work
declare @.s varchar(50)
Set @.s = 'ETK SETTLEM ESCROW ACCOUNT'
Set @.s = REPLACE(@.s,' ','')
select @.s
Maybe your syntax was incorrect
Thanks
Barry|||> I used this command: REPLACE(String,' ','')
And what happened? The syntax looks correct, but incomplete. Are you
trying to update the data in a table, or just select it without the spaces?
Give some more information other than "I did this"...