>Hi everybody,
>
>I have this string in my report:
>SUBSTR(oJC.IssMonth,3) +' YEAR-TO-DATE RECAP THRU ISSUE ' +LEFT(oJC.IssMonth,2)
>
>left(oJC.IssMonth,2) would be '07', '08', etc. I would like to print just '7' or '8' in my Report. What would be the simplest way to achive this?
>
>Thanks.
I guess
TRANSFORM( VAL( left(oJC.IssMonth,2) ))
--sb--