Thanks Jeff.

Here is the sample data

--===== Create the test table with

CREATE TABLE PROJECT

(

"PRJ_NMBR" VARCHAR2(4000 BYTE) NOT...

Thank you very much Milas. Its working good, i am still testing with still more values. 🙂