Forum OpenACS Development: Re: trim

Collapse
4: Re: trim (response to 1)
Posted by Nis Jørgensen on
I may be missing the point, but can't you just use

SUBSTR(PORTAL.OPC_SURVEY_SCORES.RESPONDENT, 1, LENGTH(PORTAL.OPC_SURVEY_SCORES.RESPONDENT) - 10)

IE ignore the fact that the characters you want to remove are digits, and just remove ten of them.

/Nis