theryno said:
Can someone help translate the following (I need to put it in a SELECT
statement):
decode(t1.field1,0,t1.field2,' '||t1.field2).
Thank you!
That would be an Oracle PL/SQL function, right? I'm not really familiar
with PL/SQL, but I believe the Switch function is very similar to the
Oracle Decode function. If the "||" operator is concatenation (see, I
told yopu I don't know Oracle), then the above expression might be
rewritten for an Access query as
Switch(t1.field1=0, t1.field2, True, " " & t1.field2)
On the other hand, that expression doesn't seem to be using more than
one condition, so you might simplify it to
IIf(t1.field1=0, t1.field2, " " & t1.field2)
