Index: openacs-4/packages/acs-tcl/tcl/community-core-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/community-core-procs-oracle.xql,v
diff -u -r1.15 -r1.15.2.1
--- openacs-4/packages/acs-tcl/tcl/community-core-procs-oracle.xql	1 Nov 2003 10:46:32 -0000	1.15
+++ openacs-4/packages/acs-tcl/tcl/community-core-procs-oracle.xql	21 Nov 2003 22:09:22 -0000	1.15.2.1
@@ -50,10 +50,10 @@
   <querytext>
       select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id
       from   cc_users u
-      where  upper(nvl(u.first_names || ' ', '')  ||
+      where  lower(nvl(u.first_names || ' ', '')  ||
              nvl(u.last_name || ' ', '') ||
              u.email || ' ' ||
-             nvl(u.screen_name, '')) like upper('%'||:value||'%')
+             nvl(u.screen_name, '')) like lower('%'||:value||'%')
       order  by name
   </querytext>
 </fullquery>
@@ -126,7 +126,7 @@
                  creation_ip
           from   cc_users 
           where  authority_id = :authority_id
-          and    upper(username) = upper(:username)
+          and    lower(username) = lower(:username)
 
       </querytext>
 </fullquery>