eXtremeSQL provides the following Null functions: coalesce(x1,x2..) Returns the first non-null value in a list of arguments ifnull(x,y) Returns x if x is not null, otherwise y nullifzero(x) Returns null if x=0, otherwise x
eXtremeSQL provides the following Null functions:
coalesce(x1,x2..)
ifnull(x,y)
x
y
nullifzero(x)
x=0