Re: Intersection of two lists

2001-02-03 Thread Dan Nelson
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

Intersection of two lists

2001-02-03 Thread Jeff Sorenson
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