TRIM()

Scalar. Returns a given string after removing leading and trailing spaces.

Syntax

TRIM( string )

Data Types
Return	string
String	String

The following example uses the TRIM function to remove leading and trailing spaces from the value in the Symbol column:

INSERT INTO OutStream
SELECT TRIM(Trades.Symbol)
FROM Trades;