By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,039 Members | 1,831 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,039 IT Pros & Developers. It's quick & easy.

help with filtering

P: 2
hi everyone. i have a question about filtering a table. i have a table with 50 columns and 900 rows. for each row, i want to goto column 5. if column 5 is equal to "1" or "2" i then want to goto column 10. if column 10 is equal to "6" or "7" i want to filter the row from the table by exluding it. how can this be done?

thanks in advance
Mar 20 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 374
hi everyone. i have a question about filtering a table. i have a table with 50 columns and 900 rows. for each row, i want to goto column 5. if column 5 is equal to "1" or "2" i then want to goto column 10. if column 10 is equal to "6" or "7" i want to filter the row from the table by exluding it. how can this be done?

thanks in advance
Expand|Select|Wrap|Line Numbers
  1. SELECT * FROM {TABLENAME} WHERE (Column5 Like 1 or Column5 Like2) AND (Column10 Not Like 6 or Column10 Not Like 7
  2.  
That is what my understanding of your filter is. You need to replace the {TABLENAME} with the table name that you're searching on since you didn't include that in your question. I'm also assuming that Column Names are Named as discribed. If you need futher help, please email me at this site.

Hope that helps,

Joe P.
Mar 20 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.