Anyone have a function to compute the size of a column?

Hi, I am working on an application which estimates the size a table will take. It looks at the data and index space for a table and therefore needs individual column sizes. This is easy for columns which are integers, character strings, etc since you can just query collength from syscolumns. However, it's not so easy for columns which are datetime since collength does not store the size dierctly. I have located the information needed to do this in the SQL guide but am looking to see if someone has already done this since it would be a tedious function to write. Thanks in advance. Bill -- --- |^^^^^^| --------------------- From the desk of Bill Ennis ---------- | (o)(o) / \\ E-mail: ennis@eis.comm.mot.com @ _) __/ Dont have \\ | ,___| /___ a cow. Dude!|