Forum OpenACS Development: Re: trim

Collapse
2: Re: trim (response to 1)
Posted by Brian Fenton on
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