Re: How to pass varchar as WHERE field IN param

[Jassm Rahma]

this is my stored procedure and it param_country is a varchar, comma separated, e.g.

BH
BH, US, IN
JP, SA, BH, FR


SELECT locations.location_id, companies.company_name, locations.location_name, first_payroll, last_payroll
FROM locations
JOIN country ON country.country_code_alpha2 = locations.country_code
JOIN companies ON companies.company_id = locations.company_id
LEFT JOIN payroll ON payroll.location_id = locations.location_id
WHERE locations.country_code IN (param_country) AND payroll_active = TRUE
GROUP BY locations.location_id
ORDER BY companies.company_name;