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:
SELECT LTRIM(Column_Name, string) AS Alias_Name FROM Table_Name; 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):
SELECT LTRIM(Original_String, trimmed_string); Syntax3: This syntax uses LTRIM function with a single character:
SELECT LTRIM(Original_String, trimmed_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:
SELECT LTRIM( ' JAVATPOINT',' '); Output:
'JAVATPOINT'
Example 2: The following SELECT query truncates the space from the specified string according to the LTRIM function:
SELECT LTRIM( ' JAVATPOINT '); Output:
'JAVATPOINT '
Example 3: The following SELECT query trims the CAPITAL OF INDIA substring from the specified string:
SELECT LTRIM( 'NEW DELHI IS THE CAPITAL OF INDIA', 'NEW DELHI IS THE '); Output:
CAPITAL OF INDIA
Example 4: The following SELECT query trims the given symbol from the specified string:
SELECT LTRIM( '####98221545###', '#'); Output:
98221545###
Example 5: The following SELECT query trims the given set of numbers from the specified string:
SELECT LTRIM( '2021JavaTpoint2021', '2021'); Output:
JavaTpoint2021
Example 6: The following SELECT query trims the given set of numbers from the specified string:
SELECT LTRIM( '202120212021JavaTpoint', '2021'); 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:
SELECT LTRIM( '90287JavaTpoint', '0123456789'); 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:
CREATE TABLE table_name
(
1st_Column Data Type (character_size of 1st Column),
2nd_Column Data Type (character_size of the 2nd column ),
3rd_Column Data Type (character_size of the 3rd column),
...
Nth_Column Data Type (character_size of the Nth column)
); The following CREATE statement creates the Faculty_Info table:
CREATE TABLE Faculty_Info
(
Faculty_ID INT NOT NULL PRIMARY KEY,
Faculty_First_Name VARCHAR (100),
Faculty_Last_Name VARCHAR (100),
Faculty_Dept_Id INT NOT NULL,
Faculty_Address Varchar(120),
Faculty_City Varchar (80),
Faculty_Salary INT
);The below INSERT queries insert the records of college Faculties in the Faculty_Info table:
INSERT INTO Faculty_Info (Faculty_ID, Faculty_First_Name, Faculty_Last_Name Faculty_Dept_Id, Faculty_Address, Faculty_City, Faculty_Salary) VALUES (1001, ' Arush ', ' Sharma ', 4001, ' Aman Vihar ', ' Delhi', 20000);
INSERT INTO Faculty_Info (Faculty_ID, Faculty_First_Name, Faculty_Last_Name Faculty_Dept_Id, Faculty_Address, Faculty_City, Faculty_Salary) VALUES (1002, ' Bulbul ', ' Roy ', 4002, ' Nirman Vihar ', ' Delhi', 38000 );
INSERT INTO Faculty_Info (Faculty_ID, Faculty_First_Name, Faculty_Last_Name Faculty_Dept_Id, Faculty_Address, Faculty_City, Faculty_Salary) VALUES (1004, ' Saurabh ', ' Sharma ', 4001, ' Sector 128 ', ' Mumbai', 45000);
INSERT INTO Faculty_Info (Faculty_ID, Faculty_First_Name, Faculty_Last_Name Faculty_Dept_Id, Faculty_Address, Faculty_City, Faculty_Salary) VALUES (1005, ' Shivani ', ' Singhania ', 4001, ' Vivek Vihar ', ' Kolkata', 42000);
INSERT INTO Faculty_Info (Faculty_ID, Faculty_First_Name, Faculty_Last_Name Faculty_Dept_Id, Faculty_Address, Faculty_City, Faculty_Salary) VALUES (1006, ' Avinash ', ' Sharma ', 4002, ' Sarvodya Calony ', ' Delhi', 28000);
INSERT INTO Faculty_Info (Faculty_ID, Faculty_First_Name, Faculty_Last_Name Faculty_Dept_Id, Faculty_Address, Faculty_City, Faculty_Salary)VALUES (1007, ' Shyam ', ' Besas ', 4003, ' Krishna Nagar ', ' Lucknow', 35000);The following SELECT statement displays the inserted records of the above Faculty_Info table:
SELECT * FROM Faculty_Info; | Faculty_Id | Faculty_First_Name | Faculty_Last_Name | Faculty_Dept_Id | Faculty_Address | Faculty_City | Faculty_Salary |
|---|---|---|---|---|---|---|
| 1001 | ‘ Arush ‘ | ‘ Sharma ‘ | 4001 | ‘ Aman Vihar ‘ | ‘ Delhi’ | 20000 |
| 1002 | ‘ Bulbul ‘ | ‘ Roy ‘ | 4002 | ‘ Nirman Vihar ‘ | ‘ Delhi’ | 38000 |
| 1004 | ‘ Saurabh ‘ | ‘ Roy ‘ | 4001 | ‘ Sector 128 ‘ | ‘ Mumbai’ | 45000 |
| 1005 | ‘ Shivani ‘ | ‘ Singhania ‘ | 4001 | ‘ Vivek Vihar ‘ | ‘ Kolkata’ | 42000 |
| 1006 | ‘ Avinash ‘ | ‘ Sharma ‘ | 4002 | ‘ Sarvodya Calony ‘ | ‘ Delhi’ | 28000 |
| 1007 | ‘ Shyam ‘ | ‘ Besas ‘ | 4003 | ‘ Krishna Nagar ‘ | ‘ Lucknow’ | 35000 |
The following SELECT query uses the LTRIM function with the Faculty_Last_Name column of the above Faculty_Info table:
SELECT Faculty_Last_Name, LTRIM(Faculty_Last_Name) AS LTRIM_LastName FROM Faculty_Info; This SQL statement trims the space from the left of the last name of each faculty:
Output:
| Faculty_Last_Name | LTRIM_LastName |
|---|---|
| ‘ Sharma ‘ | ‘Sharma ‘ |
| ‘ Roy ‘ | ‘Roy ‘ |
| ‘ Roy ‘ | ‘Roy ‘ |
| ‘ Singhania ‘ | ‘Singhania ‘ |
| ‘ Sharma ‘ | ‘Sharma ‘ |
| ‘ Besas ‘ | ‘Besas ‘ |
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:
SELECT Faculty_Id, LTRIM(Faculty_First_Name), LTRIM(Faculty_Address) FROM Faculty_Info WHERE Faculty_Id >1002; 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:
| Faculty_Id | LTRIM(Faculty_First_Name) | LTRIM(Faculty_Address) |
|---|---|---|
| 1004 | ‘Saurabh ‘ | ‘Sector 128 ‘ |
| 1005 | ‘Shivani ‘ | ‘Vivek Vihar ‘ |
| 1006 | ‘Avinash ‘ | ‘Sarvodya Calony ‘ |
| 1007 | ‘Shyam ‘ | ‘Krishna Nagar ‘ |
Leave a Reply