>>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.
>
>
>How about:
>
>
select <b>int(</b>val(right(cYear,2))) as Year, <b>int(</b>val(Period)) as Period
Once again, STUPID ME! Thanks a lot.
If it's not broken, fix it until it is.
My Blog