0 votes
1 view
in SQL by (22.4k points)

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.

Please log in or register to answer this question.

Welcome to Intellipaat Community. Get your technical queries answered by top developers !