Trim

Removes white space from the start and end of the value. When characters is given, each of those characters is removed from the start and end instead.

String Trim(String text, String characters = null)

Returns 'hi' twice.

SELECT Trim('   hi   ') as Spaces, Trim('--hi--', '-') as Dashes FROM Single

• Scalar Functions