10.7.4 AsValue
AsValue allows you to better handle *SQLNull. Rather than having to test for a potential SQL null, AsValue allows a variable to return a specified value.
Input Parameters
Default - The value to be returned when the variable contains an SQLNull.
Allowable values for a Boolean variable are 0, 1, True and False
Example
Rather than having to test as below
If ((#Boolean = True) *or (#Boolean.IsSqlNull)
Endif
AsValue allows the following:
If (#Boolean.AsValue(True))
Endif
Ý 10.7 Boolean Intrinsic Functions