Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

LTRIM

Example

Trim leading spaces from a string.

SELECT LTRIM(”     SQL Tutorial”) AS LeftTrimmedString;  

Definition and Usage

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

Syntax

LTRIM(string)

Parameter Values

Parameter

Description

string

Input required: The string from which leading spaces will be removed.

Technical Details

Works in: From MySQL 4.0