String Decode function issue

[rxs0005]

hi all

i am trying to use sting decode i have the 3 versions it still does not change it

on DB the input is VARCHAR2(10) i.e data type of PROPERTY_TYPE

StringDecode(tpo_loan_orig_out.PROPERTY_TYPE,'01=Condo under five stories|1=Condo under five stories')

StringDecode(tpo_loan_orig_out.PROPERTY_TYPE,'"01"=Condo under five stories|"1"=Condo under five stories')

I also tried this to trim it still does not work can some one advice

StringDecode(trim(tpo_loan_orig_out.PROPERTY_TYPE,"D"),'01=Condo under five stories|1=Condo under five stories')

StringDecode(trim(tpo_loan_orig_out.PROPERTY_TYPE),'01=Condo under five stories|1=Condo under five stories')

thanks

rxs0005

[roy]

Hi,
From memory only I recall last time I checked this funtion/routine was not exactly equivalent to lets us say the Oracle Decode logic.
You can build your own routine cutom made to your needs.

IHTH,