Quick Question about Where

Results 1 to 4 of 4

Thread: Quick Question about Where

  1. #1
    Jeremy #121 Guest

    Default Quick Question about Where

    I need to say<BR><BR>SELECT * FROM in WHERE Closed = (This is where I have the prob)<BR><BR>I need it to pick out records that closed = y or closed = n. Closed can = y, n, o, c, d. But I only want the y&#039;s and the n&#039;s. <BR><BR>Do I do an OR statment, I already tried AND that didn&#039;t work.<BR><BR>Thanks,<BR>Jeremy #121<BR>

  2. #2
    Mark Guest

    Default RE: Quick Question about Where

    Yeah, you would use an Or in the where....<BR><BR>SELECT * FROM in WHERE (Closed=&#039;y&#039; Or Closed=&#039;n&#039;)<BR><BR>That should work...<BR><BR>-Mark

  3. #3
    Join Date
    Dec 1969

    Default Closed in ('y','n')


  4. #4
    Jeremy #121 Guest

    Default Thank you both


Posting Permissions

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