SQL LTRIM function Working
The following diagram shows how the SQL LTRIM function affects strings in the table.
Workflow of LTRIM function
The function LTRIM in SQL analyzes the input string from the left side and removes any empty spaces or the mentioned character found on that string. The function does not alter the original string, it returns a new string where the leading whitespaces are removed.
This function doesn’t deal with whitespaces present between the strings. For example if the string ‘ JOHN’ was written as ‘ JO HN’ then only the leading white spaces on the left side will be removed by this function and the spaces in between will remain as they were earlier.
SQL LTRIM() Function
The SQL LTRIM function removes the leading space from the left of a string or string expression.
Contact Us