LTRIM Function in SQL Server

LTRIM()
Returns a character expression after it removes leading blanks.

Example :
SELECT LTRIM('   Mr. Smith')

OutPut
Mr.Smith