Forgive me if i'm being really stupid but... we have an accounts package (Exchequer) using pervasive sql. I would like to use the tables in pervasive to interrogate the db further. However my fnumeric fields e.g. Credit Limit are split into 2 fields. One is a smallint type and one is an integer. How do I combine these fields to get an accurate value?
Thanks