Hi People.... I have a table named 'csv_data_table' and it has a varchar(255) column named 'EMAIL'
This EMAIL column has multiple records with white spaces (at front and end)
I tried this way to eliminate the white space
UPDATE csv_data_table SET EMAIL = trim(EMAIL);
But it won't work.... the email values still have trailing blank spaces.
anyone know of a solution?