Upshift() in stored procedures

Posted in 1994

Martin Andrews — Thu, 15 Dec 1994 19:06:28 GMT — source: Informix-list mailing list archive (1991-1998)

I seem to remember a thread on this a ways back, but I don't remember the resolution. Is there a way to convert the case of a string in an Informix stored procedure? My goal is to have an update trigger that will maintain an all uppercase version of a column to be used in case-independent searches. -- Martin Andrews andrewm@ccfadm.eeg.ccf.org Dept. of Neurology Phone (216)444-7485 Cleveland Clinic Foundation Fax (216)445-6617