Trim colums in Sql

Remove white spaces from the beginning and the end of a column :

UPDATE TableName
    SET columnOne = LTRIM(RTRIM(columnOne)),
    SET columnTwo = LTRIM(RTRIM(columnTwo))




No Comments


You can leave the first : )



Leave a Reply

Your email address will not be published. Required fields are marked *