Re: Case insensitive queries

Peter, I have written a form with two case insensitive query fields. The pre-query trigger looks like this

        begin
            if (:email_id is not null) then


               :email_id := '# like email_id and upper(email_id) like '''


            end if;
            if (:generic_address is not null) then


               :generic_address :=


         '# like generic_address and upper(generic_address) like '''
               ||upper(:generic_address) || '''';
            end if;
            if (:email_destination is not null) then


               :email_destination :=


         '# like email_destination and upper(email_destination) like '''
               ||upper(:email_destination) || '''';
            end if;
         end;

You simply had the "if logic" for each of the fields in which you want to perform case insensitive queries.

                               Ian MacGregor
                               Stanford Linear Accelerator Center
                               (415) 926-3528