TRIM

Syntax

TRIM(<string>)

Description

Returns a copy of the string, with leading and trailing whitespace omitted.

Examples

Column1TRIM returns

    This is a test    

This is a test

Datameer

Datameer

I love dataI love data