q:remove spaces

How can you remove spaces in the middle of a string, RTRIM and LTRIM does not
workYou can use the REPLACE function.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:0A9862B7-8446-484B-99E7-19336D19EF8F@.microsoft.com...
> How can you remove spaces in the middle of a string, RTRIM and LTRIM does not
> work