simple question pass parameter thru query for like syntax.

SELECT        dbo.tblEmployerName.EmpName, dbo.tblUnionNames.Acronym, dbo.tblColAgree.ExpDate AS Expiry FROM            dbo.tblColAgree LEFT OUTER JOIN                          dbo.tblUnionNames INNER JOIN                          dbo.tblUnionLocals ON dbo.tblUnionNames.UnionID = dbo.tblUnionLocals.UnionID ON dbo.tblColAgree.UnionID = dbo.tblUnionLocals.LocalID LEFT OUTER JOIN                          dbo.tblEmployerName INNER JOIN              &nbs ...