TRIM() In SQL Server 2017

SELECT TRIM('     My test query     ')

/* Result */
My test query


SELECT TRIM( '.! ' FROM  '@     My Test Query   !..') AS Result;

/* Result */
@     My Test Query


SELECT len(TRIM( '.! ' FROM  '@     My Test Query   !..')) AS Result;

/* Result */
19


SELECT firstName, TRIM(char(32) FROM firstName) as Trim_name from Table

Firstname  TrimName
      Test      Test