吸收知識大海綿

 去除右邊空白字元:

UPDATE tableName SET ColumnName = RTRIM(ColumnName);

'ABC123   '

'ABC123'

去除左邊空白字元

UPDATE tableName SET ColumnName = LTRIM(ColumnName);

'   ABC123    '

'ABC123    '