IsNull

The IsNull function Replaces NULL with a replacement value.

Syntax :

IsNull(Value,[ValueIfNull])

Parameters :

Expression = The required expression.

Parameters Description
value The required expression.
ValueIfNull Condition stated, if the value is null.

Example :

t = IsNull(Null,5) 
t = IsNull(2,5) 

Result :

t=5
t=2