Home ›
ASP.NET Forums » General ASP.NET » Getting Started » Want to select several ID's

Want to select several ID's

Last post 08-29-2008 1:32 PM by shados. 1 replies.

Sort Posts:

  • Want to select several ID's

    08-29-2008, 1:30 PM
    • Member
      115 point Member
    • cgilbu
    • Member since 07-11-2008, 12:55 PM
    • Norway
    • Posts 182

    I got an update query that ends like this: ...WHERE CountryID Like... And here I want to be able to select several ID's. How do I do that? I am thinking about something like '2','3', etc...

    Thanks for any help!

    "Why do I live?"
    This might be the answer.

  • Re: Want to select several ID's

    08-29-2008, 1:32 PM
    Answer
    • Star
      12,114 point Star
    • shados
    • Member since 07-07-2006, 11:24 PM
    • Posts 2,201

    Where Country IN (1,2,3,4,5)

    Of course, add quotes if they're varchars instead of numeric values.
Page 1 of 1 (2 items)
RSS Available

Contact | Advertise | Ads by BanManPro | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.