SQL Server: Convert Multiple Spaces to Single Space in a String

Extra spaces between characters of a string value is a common problem and if you’re a developer then you must have faced the problem. On request of a blog reader here is a script from by query bank which I like to use to remove such extra spaces.