But I thought I would bring it to the pros (YOU!). Anyways, enuf of the *** kissing.<BR><BR>I've got a site on which people post some products for sale. On this post they have a time period of how long they want it to be posted. This is calculated and a date of EndDate goes into my SQL database.<BR><BR>I also have a field Active (1 or 0). Once the EndDate is equal to todays date, how can I get this Active field to change from 1 to 0.<BR><BR>Thanks for any help, this is my first time working with SQL Server (2000 btw).