Here's an easy one

Results 1 to 3 of 3

Thread: Here's an easy one

  1. #1
    Join Date
    Dec 1969

    Default Here's an easy one

    I am writing a simple sql statement and would like to exclude one date from the record. What is the syntax for "not"? <BR>E.G. <BR>SQL="SELECT DISTINCT Order_Number FROM Purchased_Product"<BR>SQL=SQL &" WHERE Shipdate&#062;" & today <BR>SQL=SQL &" AND Shipdate *NOT*=11/2/1978"<BR>set ordernumber=conn.execute(SQL)

  2. #2
    InstrRev Guest

    Default RE: Here's an easy one

    SQL & " Where ShipDate &#062;&#039" & Date "&#039 and ShipDate &#060;&#062;&#039 12/25/2000&#039"

  3. #3
    Steven L Guest

    Default RE: Here's an easy one

    Will this work too?<BR><BR>SQL=SQL &" AND NOT (Shipdate=#11/2/1978#)"

Posting Permissions

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