I've written a procedure that enables me to lookup fields based on their data type. I can look them up by their RDB$TYPE number or by using free text as in VARCHAR, VARYING, SMALLINT etc.

I've been able to find references that explain how to use RDB$FIELDS and the RDB$FIELD_TYPE column in conjunction with the RDB$FIELD_SUB_TYPE column to distinguish between types like SMALLINT, NUMERIC, INTEGER, etc.

I have been unable to distinguish between DECIMAL and NUMERIC types. I've read that the difference in practical terms is that a NUMERIC designation is exact whereas a DECIMAL designation is a minumum.

Is there a way to distinguish between a DECIMAL and a NUMERIC using values stored in the RDB$ tables?

Thank.

David Keith