orclz> select * from emp where upper(ename) like upper('%LL%');

     EMPNO ENAME      JOB              MGR HIREDATE                   SAL       COMM     DEPTNO
---------- ---------- --------- ---------- ------------------- ---------- ---------- ----------
      7499 ALLEN      SALESMAN        7698 1981-02-20 00:00:00       1600        300         30
      7934 MILLER     CLERK           7782 1982-01-23 00:00:00       1300                    10

orclz>

CREATE TABLE XXTEST (NAME VARCHAR2(30), DESCRIPTION VARCHAR2(50));

insert into xxtest(name,description) values('AR','ESC Accounts Receivable IT Concurrent Processes');
insert into xxtest(name,description) values('AR','RSC IT Intransit Concurrent Processes');
insert into xxtest(name,description) values('AR','RSN IT Intransit Concurrent Processes');
insert into xxtest(name,description) values('AR','RSC Accounts Receivable IT Concurrent Processes');

SELECT * FROM XXTEST WHERE UPPER(description) LIKE UPPER('%IT Concurrent%');

Name    Description
------  ------------------------------------------------------
AR	ESC Accounts Receivable IT Concurrent Processes
AR	RSC IT Intransit Concurrent Processes
AR	RSN IT Intransit Concurrent Processes
AR	RSC Accounts Receivable IT Concurrent Processes

SELECT * FROM XXTEST WHERE description LIKE '%IT Concurrent%';

Name   Description
-----  -------------------------------------------------------
AR	ESC Accounts Receivable IT Concurrent Processes
AR	RSC Accounts Receivable IT Concurrent Processes