Can someone please explain to me why this statement isn't working and correct?
--Delete climasfamily records not flagged
WHERE (((HV_Exists)<>'Y') AND ((CustomerId) <> ''));
Note: HV_Exists Datatype is NVarChar(1) and has values of either Y or NULL
CustomerId Datatype is NVarChar(50) and has values of a numeric or NULL