TRIM, LTRIM, RTRIM in SQL - Step-by-Step Execution

Concept Flow - TRIM, LTRIM, RTRIM

Start with string

↓

Apply LTRIM?

Yes→Remove leading spaces

↓

Apply RTRIM?

Yes→Remove trailing spaces

↓

Apply TRIM?

Yes→Remove both sides spaces

↓

Return original string

↓

Output trimmed string

The flow shows starting with a string, then optionally removing spaces from the left (LTRIM), right (RTRIM), or both sides (TRIM), returning the cleaned string.

Execution Sample

SQL

SELECT TRIM('  hello  ') AS trimmed,
       LTRIM('  hello  ') AS left_trimmed,
       RTRIM('  hello  ') AS right_trimmed;

This query removes spaces from both sides, left side only, and right side only of the string ' hello '.

Execution Table

Step	Function	Input String	Action	Output String
1	TRIM	' hello '	Remove spaces from both sides	'hello'
2	LTRIM	' hello '	Remove spaces from left side only	'hello '
3	RTRIM	' hello '	Remove spaces from right side only	' hello'
4	End		All functions applied	Outputs returned

💡 All trimming functions applied and outputs produced.

Variable Tracker

Variable	Start	After TRIM	After LTRIM	After RTRIM
string	' hello '	'hello'	'hello '	' hello'

Key Moments - 2 Insights

Why does LTRIM only remove spaces on the left and not on the right?

LTRIM is designed to remove spaces only from the start (left side) of the string, as shown in execution_table row 2 where the right spaces remain intact.

What happens if the string has no spaces on one side?

The trimming function for that side does nothing, so the string remains unchanged on that side, as seen in execution_table row 3 where RTRIM removes only trailing spaces.

Visual Quiz - 3 Questions

Look at the execution_table, what is the output of LTRIM on ' hello ' at step 2?

A 'hello'

B 'hello '

C ' hello'

D ' hello '

💡 Hint

Check the Output String column in row 2 of execution_table.

At which step does the function remove spaces from both sides?

A Step 1

B Step 2

C Step 3

D Step 4

💡 Hint

Look at the Function and Action columns in execution_table.

If the input string had no trailing spaces, what would RTRIM output be?

A String with left spaces removed

B String with both sides trimmed

C Same as input string

D Empty string

💡 Hint

RTRIM only removes trailing spaces; if none exist, string stays the same (see key_moments explanation).

Concept Snapshot

TRIM removes spaces from both sides of a string.
LTRIM removes spaces only from the left side.
RTRIM removes spaces only from the right side.
Use SELECT TRIM(column), LTRIM(column), RTRIM(column) to clean strings.
Useful for cleaning user input or formatting data.

Full Transcript

This visual execution shows how SQL functions TRIM, LTRIM, and RTRIM work on a string with spaces. Starting with the string ' hello ', TRIM removes spaces from both sides resulting in 'hello'. LTRIM removes only the left spaces, keeping right spaces intact as 'hello '. RTRIM removes only the right spaces, keeping left spaces intact as ' hello'. The execution table tracks each step and output. The variable tracker shows how the string changes after each function. Key moments clarify common confusions about which side spaces are removed from. The quiz tests understanding by referencing the execution table and variable states. The snapshot summarizes usage and purpose of these functions.