Compatible Unicode Intrinsic Functions - AsValue Method
Return the variable as a value if SQLNull
Member of Compatible Unicode Intrinsic Functions (PRIM_LIBI.ICompatibleUnicodeIntrinsics)
Parameters
Name |
Type |
Data Type |
Description |
Result |
*Result (Optional) |
Unicode String |
Resulting value |
Default |
*Input (Optional) |
Unicode String |
Value to use when the variable is SQLNull |
Details
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.
Example
Rather than having to test as below
If ((#Variable = Xxxx) *or (#Variable.IsSqlNull)
...
AsValue allows the following
If (#Variable.AsValue(Xxxx))
...