BillyBoyo wrote:If you want it to say 16, you have to define it as COMP-5 or use compiler option TRUNC(BIN).
However, I personally think it bad practice to not define enough digits in a field to hold the maximum logical value for that field.
Your maximum is 20. You defined with one digit, which therefore can hold a maximum value of 9. If you define with two digits (99) you'll be able to comfortably hold a maximum value (for your table) of 20.
Thank you! I didn't watch the definition carefully. Thank you.