Bookshelf Home | Contents | Index | PDF |
Siebel Developer's Reference > Operators and Expressions > Expressions > Using the IIf FunctionThis topic describes using the IIf Function with string concatenation. The following example assigns an expression to the Calculated Value property: [Field] Double quotation marks must enclose the "," string constant because double quotation marks enclose the entire value. If the Last Name field contains NULL, and if the First Name contains Bob, then the Full Name field contains the following value: Consider the following example: CalculatedValue = "[Last Name] + IIf ([Last Name] IS NULL, If the Last Name field contains NULL, and if the First Name field contains Bob, then the result contains the following value: |
Siebel Developer's Reference | Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |