BTRIM
The BTRIM function is used to remove the string specified in the argument from the given string If no string for removing default space will be removed from leading and trailing side from the string.
Syntax
BTRIM(<string value>, <string to be trimmed from the string value>)
Example‘
select BTRIM('testX','est')
The above query returns:
X