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