>How do I convert all text to uppercase before saving.
If the data is coming from a form, use the Input Mask character ! to force all data to upper case and then you don't need to use UPPER().
Mike
Michael P. Antonovich, MCSD
Email: mike@micmin.com
MicMin Associates - Orlando, FL