We have a table which have 35 different option fields the column headings are o1, o2, o3,...o35. If I'm looking for a particular option code do I have to enter each column in my query like:
where (o1='L6' or o2='L6' or 03='L6'&or o35='L6')? The problem is that the option code 'L6' could be in any of the 35 columns. Is there any other better way than type the 35 column names? Thanks!
Start Free Trial
