This blog shows how to remove the Leading spaces of a string using the LTRIM in SQL

Example:

SELECT LTRIM(' String with Leading blanks')

The expected result would be "'String with Leading blanks"