var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I am trying to gather data that my field can be any one of 200 items.
I was trying to use something like:
where charge_code in ( 123, 456, 555 ) I am thinking this is an "AND" and I want it to be an "OR" .
I wanted if charge_code if is 123 OR 456 or 555. I have over 200 entries and did not want to create 200 line compares.
Is there a better way?
So....You think the IN construct is similar to AND?
How would it be useful, if you had
IN tests for any match. Not all of them.
where charge_code = 123
and charge_code = 456
and charge_code = 789
IN clause is an OR construct. It means that the value can be any one of the values IN your list.
you don't want to list them in an IN list, either
Originally Posted by Thomasj
you want to store them in a table and then do a join