Fixed Character Intrinsic Functions - AsValue Method
Return the variable as a value if SQLNull
Member of Fixed Character Intrinsic Functions (PRIM_LIBI.IFixedCharIntrinsics)
| Name | Type | Data Type | Description |
|---|---|---|---|
| Result | *Result (Optional) | String | Resulting value |
| Default | *Input (Optional) | String | Value to use when the variable is SQLNull |
AsValue allows you to better handle *SQLNull. Rather than having to test for a potential SQLnull, AsValue allows a variable to return a specified value.
Rather than having to test as below
If ((#Variable = Xxxx) *or (#Variable.IsSqlNull) ...
AsValue allows the following
If (#Variable.AsValue(Xxxx)) ...
Febuary 18 V14SP2