Microsoft SQL Server LTrim


Returns a character expression (varchar or nvarchar) after removing all leading white spaces, i.e., white spaces from the left through to the first non-white space character.


  1. character expression. Any expression of character or binary data that can be implicitly converted to varcher, except text, ntext and image.
SELECT LTRIM('    This is my string') -- Returns 'This is my string'