Re: [SQL] Matching a column against values in code

2005-02-16 Thread PFC
This has been discussed a few hours ago on the mailing list on the subject '[SQL] More efficient OR' On Fri, 11 Feb 2005 10:12:52 -0600, Tim <[EMAIL PROTECTED]> wrote: Hello all. I sometimes find myself needing an SQL query that will return all the rows of a table in which one column equals a

[SQL] Matching a column against values in code

2005-02-16 Thread Tim
Hello all. I sometimes find myself needing an SQL query that will return all the rows of a table in which one column equals any one of a list of values I have in an array in code. Does anyone know of a better way to do this than to loop through the array and append an "or" comparison to the sql