The SQL Server RTRIM() function removes trailing spaces from a string. Trailing spaces are spaces after (right of) the string.

The SQL Server SOUNDEX() function returns a four-character code to evaluate the similarity of two expressions.

The SQL Server SPACE() function returns a string of the specified number of space characters.

The SQL Server STR() function returns a number as a string.

The SQL Server STUFF() function deletes a part of a string, starting at a specified position, and then inserts a new part into the string at that position.

The SQL Server SUBSTRING() function extracts a specified number of characters from a specified position in a string.

The SQL Server TRANSLATE() function returns the string from the first argument after the characters in the second argument are translated into it.

The SQL Server TRIM() function removes leading and trailing spaces (default) OR other specified characters from the start or end of a string.

The SQL Server UNICODE() function returns an integer value (the Unicode value) for the first character of the input expression.

The SQL Server UPPER() function converts a string to upper-case.