SQL Server LTRIM() Function

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP







<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]
-->



SQL Server LTRIM() Function




❮ SQL Server Functions



Example


Remove leading spaces from a string:



SELECT LTRIM('     SQL Tutorial') AS LeftTrimmedString;

Try it Yourself »

Definition and Usage


The LTRIM() function removes leading spaces from a string.


Note: Also look at the RTRIM() function.



Syntax



LTRIM(string)


Parameter Values





Parameter Description
string Required. The string to remove leading spaces from

Technical Details




Works in: SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data
Warehouse, Parallel Data Warehouse



❮ SQL Server Functions


-