10.11.1 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 value for a time is any valid time.
Example
Rather than having to test as below:
If ((#Blob = 'N/AVAILABLE') *or (#Blob.IsSqlNull))
Endif
AsValue allows the following:
If (#Blob.AsValue( 'N/AVAILABLE' ) = 'N/AVAILABLE')
Endif