Removing Between White Spaces in MS SQL

[Cheeky Chino]

How would i go about removing in between spaces from a string?

If i have "HI MY NAME IS AARON" and want to make that "HIMYNAMEISAARON" how can this be done in MS SQL?

I know about LTRIM and RTRIM but i dont know of anything betweeen...

Any help?
Cheers

[MattR]

Look up the "REPLACE" SQL function in the SQL Server books.

[Cheeky Chino]

Hey thanks for that it works a wonder

REPLACE(' This is my string', ' ', '')

= 'Thisismystring'