TRIM function on SQL Server 2014

Question

IN SQLite I wrote :

UPDATE MYTABLE SET MYFIELD = TRIM(MYFIELD);

What to do to have this on SQL Server 2014 ?

Answer 1

UPDATE MYTABLE SET MYFIELD = LTRIM(RTRIM(MYFIELD));

However, field type must be varchar() and not text. Otherwise you get "Argument data type text is invalid for argument 1 of rtrim function"

Answer 2

You need functions LTRIM (to trim from left) and RTRIM (to trim from right):

UPDATE MYTABLE SET MYFIELD = LTRIM(RTRIM(MYFIELD));