>>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