I am a wiz in MS Access and Hyperion, but I can’t figure out how to do if statements in Toad for Data Analysts. I want to return a value when a field is not null.
So my field has the value of 0099000 and I want to return the value of Yes.
In Access I would have done this by creating a variable in the query design view:
ABA: IIf([ABANo] Is Not Null,“Yes”)
how do I do this in TOAD?