RTRIM to remove space suffix to a string
SELECT RTRIM('plus2net.com ')// Output plus2net.comRTRIM with UPDATE
To remove blank space after the name in our student tableUPDATE student SET name=RTRIM(name)We can add space to a column and then display after removing
SELECT concat(name,' '), RTRIM(concat(name, ' ')) from studentSQL String References LTRIM() : Removing space from LEFT TRIM : Removing space from both sides of the string
Subscribe to our YouTube Channel here
This article is written by plus2net.com team.
https://www.plus2net.com
SQL Video Tutorials