Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Although your SQL statement looks syntactically OK, what happens if one value is NULL? Have you tried the SQL function CONCAT. You might have to also use an inner COALESCE function to handle NULLS? See HERE.

Although your SQL statement syntax looks syntactically OK, what happens if one value is NULL? Have you tried the SQL function CONCAT. You might have to also use an inner COALESCE function to handle NULLS? See HERE.

Although your SQL statement syntax looks OK, what happens if one value is NULL? Have you tried the SQL function CONCAT. CONCAT instead of ||? You might have to also use an inner COALESCE function to handle NULLS? See HERE.

Although your SQL statement syntax looks OK, what happens if one value is NULL? Have you tried the SQL function CONCAT instead of ||? using '||'? You might have to also use an inner COALESCE function to handle NULLS? See HERE.