In the last episode (Feb 01), Jeff Sorenson said:
> Does anyone know of an elegant way to determine, within a query, whether
> two arbitrary lists have common element?
>
> I am quite fond of queries using "in", e.g: select * from A where 23 in
> (A.list) - where A.list is a comma-separated l
Does anyone know of an elegant way to determine, within a query, whether
two arbitrary lists have common element?
I am quite fond of queries using "in", e.g: select * from A where 23 in
(A.list) - where A.list is a comma-separated list of numbers in a
varchar(255) field.
Now I need somethi