I use character(100)
>Presently we have a (VFP) table storing email addresses and the field is character (25).
>
>What is the recommended length for a character field (other than using memo field)?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer