Select iif(IsNull( express ), value1, value2 ) From TableName
iif(IsNull( express ), value1, value2 )
相当于:
If express Is Null Then
Return value1
Else
Return value2
End if
Select iif(IsNull( express ), value1, value2 ) From TableName
iif(IsNull( express ), value1, value2 )
相当于:
If express Is Null Then
Return value1
Else
Return value2
End if