Sql Server: How to remove multiple spaces from a string

Introduction:  In this article i am going to explain how to remove all spaces that may be present in the beginning(leading spaces) or at ...