Entries in UPPER in a table

[PFD]

Is there a way I can have all entries in a table automatically in caps once entered by user, import or any other way ?


Thanks a lot in advance.

-PFD

[Sundar]

You'd be better off converting the values into caps before the insert takes place. This would elimiate the additional step of doing this after the entry.


------------
PFD at 3/27/01 7:58:48 AM


Is there a way I can have all entries in a table automatically in caps once entered by user, import or any other way ?


Thanks a lot in advance.

-PFD

[MAK]

create trigger that converts everything to uppercase when u insert.
-MAK

------------
Sundar at 3/27/01 8:13:40 AM

You'd be better off converting the values into caps before the insert takes place. This would elimiate the additional step of doing this after the entry.


------------
PFD at 3/27/01 7:58:48 AM


Is there a way I can have all entries in a table automatically in caps once entered by user, import or any other way ?


Thanks a lot in advance.

-PFD