I had a table called ABC and there is a column called "EXPDATE". And now i have to update 500 columns of different expiration dates by one year less.

Ex: if my EXPDATE is 01/12/2007, My query should give an output like
01/12/2006


Please help me out.