What is the best way to remove all spaces from a string in SQL Server 2008?
LTRIM(RTRIM(' a b '))
would remove all spaces at the right and left of the string, but I also need to remove the space in the middle.
What is the best way to remove all spaces from a string in SQL Server 2008?
LTRIM(RTRIM(' a b '))
would remove all spaces at the right and left of the string, but I also need to remove the space in the middle.