List:General Discussion« Previous MessageNext Message »
From:Bryan Cantwell Date:February 17 2010 5:24pm
Subject:compare column value to anything in a list of values
View as plain text  
Is there a simple function or method to compare a value in a column to one or more items
in a comma separated list?

select * from table where value <contains one of> ('apple','orange','banana');

and say value may = something like 'produce(grape,orange,pear,apple,lettuce)'
Thread
compare column value to anything in a list of valuesBryan Cantwell17 Feb
RE: compare column value to anything in a list of valuesBryan Cantwell17 Feb
Re: compare column value to anything in a list of valuesWm Mussatto17 Feb
  • RE: compare column value to anything in a list of valuesJay Blanchard17 Feb
    • Re: compare column value to anything in a list of valuesBaron Schwartz19 Feb