[thelist] SQL question

[Ryan Carmody]

Hi all,

Is there any way to find the length of certain or all fields in a table 
using sql?  I need to set the maxlength for over 500 fields, dynamically.  
If I had to hardcode it I could, but then if a new field is added I'd have 
to go and set the maxlength.

TIA,
Ryan Carmody
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com