Hi Luis,
In Oracle, just use the RTRIM function. For example:
select rtrim('abcd123','0123456789') as trimmed from dual;
TRIMMED
------------
abcd
I guess in your case you could do:
RTRIM(PORTAL.OPC_SURVEY_SCORES.RESPONDENT, '0123456789') = RTRIM(PORTAL.WWCTX_API.GET_USER, '0123456789')
Hope this helps
Brian
