MySQL WHERE clause construction issue
===

I use this to filter records by LocState:
(States are passed as pipe delimited values like shown below but will be a parameter)

    INSTR(CONCAT('|','TX|OH','|'),e.LocState) > 0

But...how can I make it work for something like this?:

    INSTR(CONCAT('|','AO|WH15','|'),e.ProgramCode) > 0

It also causes a match for ProgramCode == 'WH1'.

    POSITION(e.ProgramCode IN CONCAT('|','AO|WH15','|')) > 0

Doesn't work either.

