locked
Shorthand for where clause RRS feed

  • Question

  • User-1598327559 posted

    I was curious to know if SQL provides shorthand for the following:

    WHERE (((tblProducts.Brand)="Lamborghini")) OR (((tblProducts.Brand)="Ferrari"));

    I.E. is there a way to do something like tblProducts.Brand="Lamborghini","Ferrari"

    Sunday, September 22, 2013 11:56 PM

Answers

  • User-1716253493 posted
    WHERE (tblProducts.Brand IN ('Lamborghini','Ferrari'));

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, September 23, 2013 12:09 AM

All replies

  • User-1716253493 posted
    WHERE (tblProducts.Brand IN ('Lamborghini','Ferrari'));

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, September 23, 2013 12:09 AM
  • User-1598327559 posted

    Ahhh now my code looks so much cleaner.  Thanks a bunch

    Monday, September 23, 2013 9:55 PM