store column values capitalized

Posted in 2004

tomL — 30 Jun 2004 13:20:04 -0700 — source: Usenet: comp.databases.informix

hello all! is it possible to have the database store everything entered into a field as capitalized ? we would do this to avoid having to run the UPPER function in any code/sql. thanks Tom

↪ replying to tomL

Enor P — Wed, 30 Jun 2004 21:50:05 +0100 — source: Usenet: comp.databases.informix

tomL wrote: > hello all! > > is it possible to have the database store everything entered into a > field as capitalized ? we would do this to avoid having to run the > UPPER function in any code/sql. Is can do with 9.x user defeined data type. Cannot think of other way. -- Enor