Chapter 16 – Substrings and Positioning Functions
“It’s always been and always will be the same in the world: the horse does the work and the coachman is tipped.”
The TRIM Command trims both Leading and Trailing Spaces
,Trim(Last_Name) AS No_Spaces
,Trim(Both from Last_Name) AS No_Spaces
Both queries above do the exact same thing. They remove spaces from the beginning and the end of the column Last_Name.
Both queries trim both the leading and trailing spaces from Last_Name.
A Visual of the TRIM Command Using Concatenation