var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: default value in query
Is there a way to for a query to return a default value (specified in the query) if a request value is NULL?
In my case I am returning an average wage for each employee record but people without wages should return some sort of default amount rather than just blank/null.
SELECT employee, AVG(COALESCE(wagefield, 0))
"0" in this example is the default value.
Awesome, thanks for the help. It worked perfect.