>>>>>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?
>>>>>
>
>Nadya,
>
>SELECT Whatever + 0000000000 ... will give N(10)

Right, but if you want to convert char to numeric in Query, it would not help.

Thanks.