Hey Oscar - where's his stars???

>Thanks a lot Craig
>
>Oscar
>
>>>Standard length fields
>>>
>>>Most of my database design is aimed to Mexico and Latin America. However, this time I need to create a database where common used standard fields will be there for the American and International user.
>>>
>>>I’ll appreciate any advice about field lengths for the next list of fields.
>>>
>>>Thanks in advance
>>
>>
>>I'm not sure there is a standard for some of these, but here's what I typically use...some, like phone, SSN and zip are standard.
>>
>>Phone- 10 (no formatting saved)
>>Addres- 40
>>City- 30
>>Social Security No.- 9 (no formatting saved)
>>Zip - 9 (no formatting saved)
>>First Name- 20
>>Last Name- 20
>>Second Name- 20