>>>I need to determine the size of numeric fields in SQL tables. I know how to get the decimal positions but I cannot find out how to determine the significant positions. Some thing like Numeric(???,4) I need to determine the ??? value. How can I retrieve this information from the SQL schema?
>>>
>>>Thanks
>>>
>>>Glenn
>>
>>

>>SELECT NUMERIC_PRECISION,
>>       NUMERIC_SCALE
>>FROM INFORMATION_SCHEMA.Columns
>>WHERE Table_Name = 'YourTable' AND 
>>      Column_Name = 'ColumnName'
>>

>
>Thanks Borislav but this does not return the ???. For instance lets say that you have a field defined as (5,2) and you run this query. it will return 10,2
>
>Truly a SQL mystery.
>
>Glenn


Are you sure?
You maybe watch NUMERIC_PRECISION_RADIX instead of NUMERIC_PRECISION?