I need to figure a way to create a table column that will allow for me to be able to
say "IF column =" and then specify more than a single value. for instance, select all
from the table where the column in question is either 1, 3, 4, and/or 7. However, I
want this column to be able to hold more than just a single value. for instance its
value would be 1, 4 or something similar like that. Is this something that you would
accomplish with a single column or would you use multiple columns to accomplish this.
Also, what datatype do you assign do the column if it can be done in one?