Hi Focals,

how can i remove leading zeros in an alpha field?? Sometimes i have one, or two or three leading zeros. And i can't compare this with another alpha field. I know numbers in alpha is not so smart, but i can't change the data structures.

Regards

Christian

This message has been edited. Last edited by: ChristianP,

-SET &AF = '000123456';

-SET &NEWAF  = GETTOK(&AF,&AF.LENGTH,1,'0',&AF.LENGTH-1,'A&AF.LENGTH');

Use the TRIM function. It's documented in the Help file of Developer Studio. You can also take a look at the documentation online. TRIM is listed under Character Functions of the Using Functions documentation. http://ecl.informationbuilders...ns/source/opener.htm

If you are absolutely certain that your &var is numeric, you can use the INT function.

EricH

All this platinum around such a basic question.
Does this metal turns devaluated ?
As a tin member I'd like to remind TOTONUM/I5 = EDIT (TOTO);( If not numeric ---> 0; TOTO should not be Longer than ??? characters )
Any way, I reread TRIM, and thank you for this efficient advice
Cordially (but not so much) and Focusely

Hi Baillecl,
i think the amount of entries, says nothing about the skill level in WEBFOCUS. As a german proverb says "there are no stupid questions, only answers". Anyway thanks to all Focals, my problem is solved. That is the reason for joining the forum.

Thanks

Christian

nb: perhaps b/c EDIT won't translate to SQL.

quote:

there are no stupid questions, only answers

Actually, there are stupid questions. They are the ones that do not get asked ...