Return (From values In Location.getData _
                Where (values.LocName.Contains(SearchTerm) _
                Or values.Address.Contains(SearchTerm) _
                Or values.Address2.Contains(SearchTerm) _
                Or values.City.Contains(SearchTerm) _
                Or values.State.Contains(SearchTerm) _
                Or values.QIM.Contains(SearchTerm) _
                Or values.MacID.Contains(SearchTerm) _
                Or values.Phone.Contains(SearchTerm) _
                Or values.PrimServ.Contains(SearchTerm) _
                Or values.Zip.Contains(SearchTerm) _
                Or values.Area.Contains(SearchTerm) _
                Or values.Type.Contains(SearchTerm)
                ) And (values.Status <> "Closed" Or status_parm = "Closed")
            Select values)