AdventureWorks Database: Remove spaces at the end of a string

Last update on December 20 2024 11:57:56 (UTC/GMT +8 hours)

71. Write a query in SQL to remove the spaces at the end of a string.

Sample Solution:

-- Concatenating the string 'text then five spaces     ' with 'after space' and aliasing it as "Original Text"
SELECT CONCAT('text then five spaces     ','after space') as "Original Text",

-- Concatenating the trimmed version of the string 'text then five spaces     ' with 'after space' and aliasing it as "Trimmed Text(space removed)"
CONCAT(RTRIM('text then five spaces     '),'after space') as "Trimmed Text(space removed)";

Explanation:

• The SQL query concatenates two strings together and provides two variations of the concatenation.
• In the first concatenation:
• The CONCAT() function concatenates the string 'text then five spaces ' with 'after space'.
• The result is aliased as "Original Text".
• In the second concatenation:
• The RTRIM() function trims any trailing spaces from the string 'text then five spaces '.
• The CONCAT() function then concatenates the trimmed string with 'after space'.
• The result is aliased as "Trimmed Text(space removed)".

Sample Output:

Original Text                        |Trimmed Text(space removed)     |
-------------------------------------+--------------------------------+
text then five spaces     after space|text then five spacesafter space|

SQL AdventureWorks Editor:

Practice Online

Contribute your code and comments through Disqus.

Previous: Return rightmost eight characters from product name.
Next: Fetch the product name ends with the letter 'S' or 'M' or 'L'.