declare @dir varchar

SET @dir = '4, 2'

SELECT *, empresa FROM DIRETORIAS WHERE (empresa IN (@dir))

change and try as follows :

''Note : you have to remove quote (') if it...