[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))
8/22/2022 - Mon
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!