I have a database table called contracts. contracts has a varchar column that contains dates
for example 01/12/2009, 01/12/2010 etc
I would like to update the values to yes or no. if the date is in the past then yes, if in the future then no...
can anyone give me an example of the statement i need please