I got a query that does a summary, thing is, one of the fields is an LEFT JOIN thus can return NULL in some cases, how do I handle this?
The particular field looks like this:
PRICE.PRICEOUT * (100 - DISC.DISC) / 100 / PROD.QUANTITY AS finalprice
DISC.DISC can be NULL (actually, its mostly null) :P
I'd like NULL to be 0.
Doing some google, IFNULL(expression, substitute) turns up, but it seems to be mysql, is there an equiveland for MSSQL?