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
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