SELECT RTRIM(‘ Author ‘) AS Name; Output will be without any trailing spaces. The LTrim function to remove leading spaces and the RTrim function to remove trailing spaces from a string variable. It uses the Trim function to remove both types of spaces and means before and after spaces of string.Click to see full answer. Beside this, how do you use Rtrim and Ltrim in SQL?RTRIM() function removes any trailing blanks from a string or column. And LTRIM() removes blanks from the beginning of a string instead of end. expression whixh you want to use with these functions must be of a data type that is implicitly convertible to varchar.Similarly, how remove left and right space in SQL? The LTRIM() function removes space from the left side of String so you can use it to get rid of leading space, while RTRIM() removes white-space from the right side of String so you can use it to delete trailing space. Herein, what is Rtrim in SQL? The SQL RTRIM function is a SQL String Function that removes the empty spaces from the Right hand side of a character expression.How do I trim a string in SQL Server?The TRIM() function removes the space character OR other specified characters from the start or end of a string. By default, the TRIM() function removes leading and trailing spaces from a string. Note: Also look at the LTRIM() and RTRIM() functions.