SQL update query

Results 1 to 2 of 2

Thread: SQL update query

  1. #1
    Join Date
    Dec 1969

    Default SQL update query

    Hello,<BR>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.<BR>Jamie

  2. #2
    Culture Guest

    Default RE: SQL update query

    Del * from table where<BR>enddate &#060; date()<BR>and enddate is not null<BR>and enddate &#060;&#062; #1/1/1900#

Posting Permissions

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