Select * from table where ','||mycol||',' like '%,214,%';
is probably better as
Select * from table where mycol like '%21%' could match against "211, 121" etc
|
Results 1 to 10 of 13
Thread: Decode, can I use it?Threaded View
|
Click Here to Expand Forum to Full Width |