Is there a way to run a query so that it ignores the case, and the query is not case sensitive? The data being stored is "m1234" Query Select item number from item where item_code = "M1234" ; The query above should return the data above. TIA Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax : (252) 237-1592
