SELECT ContactID, SourceID FROM Contacts WHERE ContactID IS NOT NULL AND ISNUMERIC(SourceID) = 1 AND SourceID <> 0
Conversion failed when converting the nvarchar value 'X' to data type int.
to not get executed due to the failure of the previous
SourceID <> 0
I have tried IF and CASE type solutions to no avail.
ISNUMERIC(SourceID) = 1
From novice to tech pro — start learning today.