Return trimmed string from the query

[Igor Korot]

hi, ALL,
Is there an option to return a trimmed string from the query?

If I try to retrieve the char(10) from the table and the field only have
"abc", how to prevent the value to be returned as "abc     "?

Thank you.