Jason Dodson wrote:

>
> Anyway, the very term "Normalization" means "the process of removing
> redundant data from your tables in order to improve storage efficiency,
> data integrity and scalability". Having an UPPERized field is redundant
> data. It has no extra value other then it saves you from doing work in
> your application.

The UPPER version of a field is derived and relational theory might
require that you have a separate table with two fields containing the
mixed case name and the upper case name. However, there's no inherent
rule against derived data.

Regards,


Ann