I am using a union query to pull policy numbers from two tables together for a search. What I would like to accomplish is to add a wild card to is so that the parameter for searching by the name will look within the field. In a standard query, I'd just set the criteria for the name to be Like "*" & [What is the Clients Last Name, First Name?] & "*", but in SQL, this doesn't seem to work.
SELECT [PolNum], [Status], [Plan_Name], [SSN], [Name]
FROM dbo_SiouxFalls_POLICYLIST
WHERE (([Name] = [What is the Clients Last Name, First Name?] ) AND ([Role] ="10"))
UNION SELECT dbo_T_POLICY.pm_policy_number, dbo_T_POLICY.pm_status_ind, dbo_T_POLICY.pm_company_code, dbo_RoleClient.CL_TIN, dbo_RoleClient.[Last,FirstName]
FROM dbo_RoleClient INNER JOIN dbo_T_POLICY ON dbo_RoleClient.RIR_ROLE_POLICY = dbo_T_POLICY.pm_policy_number
WHERE (((dbo_RoleClient.[Last,FirstName]) = [What is the Clients Last Name, First Name?] ) AND ((dbo_RoleClient.RIR_ROLE_ROLE)="00"));
SELECT [PolNum], [Status], [Plan_Name], [SSN], [Name]
FROM dbo_SiouxFalls_POLICYLIST
WHERE (([Name] = [What is the Clients Last Name, First Name?] ) AND ([Role] ="10"))
UNION SELECT dbo_T_POLICY.pm_policy_number, dbo_T_POLICY.pm_status_ind, dbo_T_POLICY.pm_company_code, dbo_RoleClient.CL_TIN, dbo_RoleClient.[Last,FirstName]
FROM dbo_RoleClient INNER JOIN dbo_T_POLICY ON dbo_RoleClient.RIR_ROLE_POLICY = dbo_T_POLICY.pm_policy_number
WHERE (((dbo_RoleClient.[Last,FirstName]) = [What is the Clients Last Name, First Name?] ) AND ((dbo_RoleClient.RIR_ROLE_ROLE)="00"));