SQL SERVER – How to remove extra spaces from string value

How to remove extra spaces from string value is a common issue and we usually come across this issue while massaging the data. I used this solution as a part of a solution in one of my earlier solutions. Let me create a sample to demonstrate the solution. SOLUTION 1 : Using REPLACE(string) Function In … Continue reading SQL SERVER – How to remove extra spaces from string value