Hope someone can help, I don't know if this possible.
I have a UNION query. The first half selects several fields including a field called NCAT which is of type VARCHAR. If that field is empty, the output for that field is empty.
So far so good.
When I union this, I am including the line
CAST(NCAT AS INT)+ 210 AS NCAT
which adds 210 to another field if certain criteria are met.
This has the unwanted effect of returning a zero for all of the fields that were previously empty.
I want them to remain empty - is there a way I can achieve this?
Thanks in advance 
Casting a VARCHAR to INT returns zero if null?
Posted - 12/13/2012 : 10:27:46
