IF statements in calculated fields

By: Quinn Wildman

Abstract: IF statements cannot be used in calcualted fields. Use Stored Procedure is the best solution.

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.

Server Response from: ETNASC04