I have a database table called contracts, I have a datetime field in the table called renew, the field contains datetime values. what i would like to do is up date the values to yes or no. basilcally if the renew date is in the past set the value to yes if the date is in the future set to no.
firstly do i need to create a new column
secondly can anyone please give me the code to do the update please.?