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!
Thanks a lot in advance.
If it's not broken, fix it until it is.
My Blog