SQL query

Results 1 to 2 of 2

Thread: SQL query

  1. #1
    Join Date
    Dec 1969

    Default SQL query

    Does anybody know the SQL to delete a record if the end date is &#060; than today BUT do not delete if the End date is blank or is = to 1/1/1900 ? <BR><BR>Cheers.

  2. #2
    Heaven's Martini Guest

    Default Yes

    Yep, I know.<BR><BR>Do you want the answer?<BR><BR>Do you mean blank or NULL, i will assume null<BR><BR>delete tblname where (((enddate NOT NULL) <BR> (enddate &#060;&#062; &#039;1/1/1900&#039;)) AND (enddate &#060; getDate()))

Posting Permissions

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