sql replace remove spaces code example

Example 1: sql update table remove spaces

LTRIM(RTRIM(ColumnName))

Example 2: remove all spaces from string sql

SELECT REPLACE(' Hello World ',' ')