Decode, can I use it?

[gamyers]

It works fine, because I've added the commas before and after mycol.

create table mt (mycol varchar2(200));

Table created.

insert into mt values ('214');

1 row created.

Select * from mt where ','||mycol||',' like '%,214,%';

MYCOL
----------------------------------------------------------------------------------
214