As you've now found out T-SQL doesn't have a
TRIM
function, you can use
RTRIM
and
LTRIM
instead, e.g.
RTRIM(LTRIM([Column New]))
you can also make your own
TRIM
function
CREATE FUNCTION dbo.TRIM(@string VARCHAR(MAX)) RETURNS VARCHAR(MAX)
BEGIN
RETURN RTRIM(LTRIM(@string))
END