I need some modification to the following posts answer.
I want to change the following code
SELECT * FROM Wordings
ISNULL( DateFields , '' ) >= CASE WHEN Wording LIKE '%My Wording%' THEN '1/1/16' ELSE ISNULL(DateFields ,'') END
that in case the wording is found then instead of selecting where datefields >= '1/1/16', I want to put the following "EmployeeID in (select id from employeestbl where datefields >= '1/1/16')"
PS. The reason for this change is that the date field is in another table.
Thanks in advance.