define length of numeric result?

[DanNorris2000]

is there any way to define a maximum length for the following: int(Ledger.bookper/100)-1900) as bookyr
without converting to character? It currently defaults at Numeric 14,0 I would like it to be a length of 3 no decimals.

 

[rgbean]

Dan,
It really depends on where you are using this code. If you are putting this value into a table of cursor, then just define the field N (3,0). In other places, you might get what you want by adding Mod(..., 1000) "around" your calculation. If this is part of a SQL SELECT, then you might want to try ... + 000. i.e.:
int(Ledger.bookper/100)-1900)+000 as bookyr

Rick