that use expressions, or that coerce data types, the syntax can get a little hairy at first. Fortunately, there are database development tools that can generate correct SQL queries for you ...

The ANSI SQL function COALESCE is supported. summary-function is described in summary-function. query-expression is described in query-expression. USER is a literal that references the userid of the ...