How to cut space in middle word

[LTMKH]

Hello , I want to cut out all space in my text "Where are you now?", so i want this"Whereareyounow?" Can any want help me (SQL)?

[Niladri_Biswas]

Try this

declare @str as varchar(100)
set @str = 'Where are you now?' -- original data
select REPLACE(@str,' ' ,'') as RemoveSpace

Output:

RemoveSpace
Whereareyounow?

This will even work for 'Where        are    you      now?' Let me know in case of any concern. :)

Niladri Biswas

modified on Monday, November 9, 2009 11:42 PM

[LTMKH]

now i reach my result..thanks alot