10.10.7 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 ((#Time = 00:00:00) *or (#Time.IsSqlNull)
Endif
AsValue allows the following
If (#Time.AsValue( 00:00:00 ) = 00:00:00)
Endif
Ý 10.10 Time Intrinsic Functions