>That worked great. Thanks Sergey. I don't know why but I thought those were not available in SQL Server...
>
>
>>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?
>>>
I just saw that the PK is varchar, is that so or you just use PK?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.