>I think, that you can use:
>
>sele eval(right(cyear,2)), eval(cperiod)...
>
This works, but only if !empty(cYear). Otherwise I get an error.
Thanks for the idea, it's nice and simple.
>
>
>>>>>>>>>>>>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!
If it's not broken, fix it until it is.
My Blog