Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    28

    Unanswered: multiple values for single column in where clause

    how does one specify multiple values for a single column in a where clause?

    example:
    Code:
    SELECT fname, lname
    FROM tblContacts
    WHERE (state = 'MI','CA','AZ','TN','NJ')
    if my memory serves me there is an IN() value list operator but I can't remember the syntax

  2. #2
    Join Date
    Aug 2003
    Location
    Kingston, Ontario
    Posts
    106
    USE pubs
    SELECT pub_name
    FROM publishers
    WHERE pub_id in ('1389', '0736')
    See BOL for more.

  3. #3
    Join Date
    May 2004
    Posts
    28
    yup, thanks dude

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •