Using LTRIM, We can remove extra spaces from a string from the left hand side of the string:-
SELECT LTRIM(' This Is Me.');
Output is:- This Is Me. (without leading spaces)
SELECT LTRIM(' This Is Me.');
Output is:- This Is Me. (without leading spaces)