Re: I'm looking for a special kind of decode

From: <casey.kirkpatrick_at_gmail.com>
Date: 11 Jan 2005 10:31:11 -0800
Message-ID: <1105468271.561760.321520@f14g2000cwb.googlegroups.com>

If c1 is your column name:

DECODE(SUBSTR(c1,INSTR(c1,'chosenAnswer=',1,1)+14,1),'t','a',
DECODE(SUBSTR(c1,INSTR(c1,'chosenAnswer=',1,2)+14,1),'t','b',
DECODE(SUBSTR(c1,INSTR(c1,'chosenAnswer=',1,3)+14,1),'t','c',
DECODE(SUBSTR(c1,INSTR(c1,'chosenAnswer=',1,3)+14,1),'t','d'

)))) result Received on Tue Jan 11 2005 - 12:31:11 CST