• Replacing just some of the spaces and not other spaces with no precise set of rules means the Mark I eyeball is going to have to be used to do this. IF you have a clear logical mechanism for defining which spaces to remove, here is where the string manipulation functions are.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning