Datatype mismatch in criteria or expression error
Posted on 2014-01-03
Experts, is the below sql how to handle Nulls?
[import-CSM2].[Guarantee Code] and [c].[GuaranteeCode] are both number format if that matters and one has a space and other doesnt. I suspect I am getting the error because either of those fields are Null. I dont get a syntax just the "datatype mismatch in criteria or expression" error on run.
I am only needing to know if the below is the correct way to handle Nulls. If so, then there's another issue, which I am not interested in knowing the solution to right now.
here's a portion of the SQL WHERE: (if need it all let me know)
OR (((Exists (Select *
from tblLetterOfCredit c
where Nz([import-CSM2].[Guarantee Code],0) = Nz( [c].[GuaranteeCode],0)))=False))