Re: PL/SQL substr(instr oracle

YC_CHOICE_IS_MY_CHOICE ===> YC_CIMC Assuming you have four underscores in your txt

select substr(txt,1,instr(txt,'_')-1) || substr(txt,instr(txt,'_')+1 ,1)||

              substr(txt,instr(txt,'_',2)+1,1) ||substr(txt,instr(txt,'_',3)+1,1)
		|| substr(txt,instr(txt,'_',4)+1,1)

from t1 Received on Wed Jun 18 2003 - 14:23:50 CDT