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