Thanks Naomi.


>You should be able to get the information from INFORMATION_SCHEMA.Columns or other systems views, say, sys.Columns in SQL Server.
>
>>Thanks Bonnie,
>>
>>Interesting though. If you can define anything (decimal places) in the database environment, you should be able to retrieve it one way or another no?
>>
>>If I remember correctly, "decimal places" is supported by standard SQL no?
>>
>>It's probably me.
>>
>>Thanks and kind regards,
>>
>>Marc
>>
>>PS : I totally agree that decimal places is not a storage but a formatting issue. Is it blasphematory then to want to define formatting at the DB level?
>>