Hi Russel,beginning with DB2 V10 you can create an index like:CREATE INDEX qual.tablex1 ON qual.table (lower(attr,' ') asc );Of course this has to be done within DB2. Ondemand does not support thisregardsEgon