M Mustafi Guest Feb 28, 2002 #1 Hi whats the access equivelant of the PL/SQL "decode" statement. Thanks Mustafi
S SimonC Registered User. Local time Today, 12:31 Joined Feb 25, 2002 Messages 48 Feb 28, 2002 #2 Could you describe what the PL/SQL "decode" statement does? Thanks, Simon
C cliffda Guest Mar 5, 2002 #3 If you're asking about the decode function that I'm thinking of, the immediate if function will work: iif(expression,true part, false part) It's not exactly like decode but you can get the same results. For instance: select iif(1=2,"It's true","It's false") as example from dual; would result in example ------- It's false Just like decodes, you can nest iif() functions.
If you're asking about the decode function that I'm thinking of, the immediate if function will work: iif(expression,true part, false part) It's not exactly like decode but you can get the same results. For instance: select iif(1=2,"It's true","It's false") as example from dual; would result in example ------- It's false Just like decodes, you can nest iif() functions.
