>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