TRIM trailing spaces of entire field

[selavarti]

Hello,

I have to trim trailing spaces on a feild on both sides.

I did


select TRIM(eqvn_name) as eqvn_name from eqvn where eqvn_name like '% ';

eqvn_name is varchar

I feel this is right. But after running TRIM function when I query to check if there are any with trailing spaces. It is returning same set of results. Am I doing something wrong?

Thank you

 

[carp]

A SELECT will not change the data - it just changes how it is presented as a result of the query. The data in the table is not changed. If you are trying to get the trailing spaces out of your data, try

UPDATE eqvn SET eqvn_name = TRIM(eqvn_name);
COMMIT;

 

[selavarti]

I just realised it and finished the job. So dumb of me.

Thanks anyways