Q. Can I use an IF statement in a calculated field? I want to do something like:
COMPUTED BY (IF (condition) then expression1 else expression2)
A. IF cannot be used in this manner. The best solution to this problem is use a stored procedure instead.
Last Modified: 13-DEC-00