“IN” can be used to match multi columns in SQL Server,

DECLARE @t TABLE (name varchar(100),name2 varchar(100))
INSERT INTO @t VALUES(‘AB’,'D’)
INSERT INTO @t VALUES(‘C’,'AB’)
SELECT * FROM @t WHERE ‘AB’ IN(name,name2)

RESULT :

name    name2
AB         D
C            AB