LTRIM Function in SQL

This string function truncates the given character or sub-string from the left of the given original string. It also truncates the space from the left of the specified string.

Syntax of LTRIM String Function

Syntax1: This syntax uses the LTRIM function with the column name of the SQL table:

In the syntax, we have to specify the name of that column on which LTRIM function is to be run.

Syntax2: This syntax uses the LTRIM function with the set of characters (string):

Syntax3: This syntax uses LTRIM function with a single character:

Examples of LTRIM String function

Example 1: The following SELECT query truncates the given space from the specified string according to the LTRIM function:

Output:

'JAVATPOINT'

Example 2: The following SELECT query truncates the space from the specified string according to the LTRIM function:

Output:

'JAVATPOINT           '

Example 3: The following SELECT query trims the CAPITAL OF INDIA substring from the specified string:

Output:

CAPITAL OF INDIA

Example 4: The following SELECT query trims the given symbol from the specified string:

Output:

98221545###

Example 5: The following SELECT query trims the given set of numbers from the specified string:

Output:

JavaTpoint2021

Example 6: The following SELECT query trims the given set of numbers from the specified string:

Output:

JavaTpoint

Example 7: The following SELECT query trims all the numbers from the left side of the string which are present in the trimmed string:

This command actually removes the individual occurrence of numbers of the trimmed string.

Output:

JavaTpoint

Example 8: This example uses the LTRIM function with the table in Structured Query Language.

First, we have to create the new SQL table, which helps to understand the LTRIM string function. The syntax for creating the new table in the SQL database is as follows:

The following CREATE statement creates the Faculty_Info table:

The below INSERT queries insert the records of college Faculties in the Faculty_Info table:

The following SELECT statement displays the inserted records of the above Faculty_Info table:

The following SELECT query uses the LTRIM function with the Faculty_Last_Name column of the above Faculty_Info table:

This SQL statement trims the space from the left of the last name of each faculty:

Output:

The following SELECT query uses the LTRIM function with the Faculty_First_Name and Faculty_Address columns of those faculty whose faculty_Id is greater than 1002 in the above Faculty_Info table:

This SQL statement trims the space from the left of the first name and address of those faculties whose Id is greater than 1002.

Output: