Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using IF statement in a SELECT WHERE
Thank you. Now that I look at it, it seems obvious... -
Using IF statement in a SELECT WHERE
I have a table of updates that I wish to compare against the a database to find those records with differences. Each update record has a cat_id. Some updates have an alt_cat_id. I need a select to search to search if these differ, but only search for the alt-cat_id if it is populated. I don't...
