>I messed up. I just checked and I misunderstood originally, it is NOT a datetime field. It is:
>
>PK, varchar(14), not null
>
>so I guess it would be looking for '07' in position substr(sqlvalue,3,2) and replacing substr(sqlvalue,3,2) with '06' for the correct value... Can that be done in sql server?
>
Sure, SUBSTRING and REPLACE functions.
http://msdn.microsoft.com/en-us/library/aa258891(SQL.80).aspx
If it's not broken, fix it until it is.
My Blog