framework/resources/Functional/p1tests/trim_trailing_from.q

select trim(trailing 'n' from 'nixon') from voter where voter_id=46;