before insert or update trigger that inserts all upper case

before insert or update trigger that inserts all upper case

Post by Rob Willia » Wed, 13 Jul 2005 03:50:42


Does anyone have a before insert or update trigger already written
that inserts or updates only upper case charaters into a column of a
table. I have been seardhing some of my books but can not find one.
If any one has one they have been using and wouldn't mind sharing that
would be great.
Rob
 
 
 

before insert or update trigger that inserts all upper case

Post by DA Morga » Mon, 18 Jul 2005 00:02:32


Sybrand's answer is spot on.

But also look at the examples at www.psoug.org
click on Morgan's Library
click on Table Triggers
--
Daniel A. Morgan
http://www.yqcomputer.com/
XXXX@XXXXX.COM
(replace x with u to respond)