DECODE function

[fc2]

Hi,

Is it possible to put a like('') function inside a decode function as follows:

DECODE(Reference,like('%_%'),'Has Underscore','No Underscore')

I am attempting to decode a value and if it contains an underscore I want to display 'Has Underscore', else 'No Underscore'.

Can this be done? I keep getting errors!

 

[PHV]

I'd use a CASE WHEN construct

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[nagornyi]

DECODE(INSTR(Reference,'_'),0,'No Underscore','Has Underscore')