Where not(source.field) is null
does not make any sort of sense to me
Where not source.field is null
Where not (source.field is null)
in proper SQL you might find a use for the NullIf function which is a sort of inverse of IsNull
useful if someone in the past got round a nullability problem by putting rubbish in the field.
Keep Up with TechRepublic