I think, that you can use:

sele eval(right(cyear,2)), eval(cperiod)...



>>>>>>>>>>>your mesage below
Hi everybody,

I have a table with cYear, Period and other fields. cYear is 4 character representation of the year, Period is 2 chars field. 01-12 for months.

The result of Query should have Year (N 2) field - 2 last digits and Period (N 2)
I tried select val(right(cYear,2)) as Year, val(Period) as Period ..., but it formats the result to be N 2.2 Is it possible to change without messing around with set decimals?

It's URGENT!