Yes, you can use SUBSTRING() and STUFF() functions.

>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?
>