This article is tagged with:
Sql update table remove spaces
and mysql
sql update table remove spaces
LTRIM(RTRIM(ColumnName))
LTRIM(RTRIM(ColumnName))