Case insensitive queries

Finally actually trying to set up some of our SQL*Forms so that they are at least somewhat user-friendly. One of the issues is the case-sensitivity that everyone loves to hate.

The example in the Advanced SQL*Forms Techniques didn't execute when I typed it in as shown, but at least it gave me something to work from. After a bit of fiddling, I now do indeed have code that does do a case-insensitive query on one field.

I tried expanding it to provide this one two fields, but it doesn't work. I simply get back that the query caused no records to be returned, which is what I got with the example in the book.

At the moment, I have:

      DEFINE TRIGGER

         NAME = PRE-QUERY
         TRIGGER_TYPE = V3
         TEXT = <<<
         :DESCRIPTION := '#is not null and upper(DESCRIPTION) like ''' ||
               upper(:DESCRIPTION) || '''';


         >>>


      ENDDEFINE TRIGGER

Has anyone out there written a form with multiple case-insensitive fields?

Peter Grant           ////////  ///////  ////////  //    //  //    //  ////////
grant_at_triumf.ca         //     //    //     //    //    //  ///  ///  //
                       //     ///////      //    //    //  ////////  ///////
                      //     //  //       //    //    //  // // //  //
                     //     //    //  ////////  //////   //    //  //
                                               Canada's National Meson Facility
__________________________________________ _        Vancouver, British Columbia

             Communications Officer, Vancouver Oracle Users Group