WHERE INSTR('#'||input_string||'#', '#'||col||'#') <> 0
would be even nicer - it should deal with variable length substrings.