What is the best way to have Oracle ignore case on an input field whenusing a select....is there a way without using upper or lower?? Annamarie McGowanFISC DC-MMK603-791-7579annamarie.[Email address protected] Oracle LazyDBA home page