TRIM

TRIM ([{LEADING | TRAILING | BOTH} [string] FROM] string)

Description

Removes all leading spaces, trailing spaces, or spaces at both ends, from a string. Other characters can be removed as well.

Examples

SELECT TRIM(BOTH '_' FROM NAME) FROM Players;