>SQLServer 2000
>
>About 100 records had the month in a datetime field set wrong. I need to set them back but only the month portion in a datetime field. For example:
>
>SQL DATE: 0807171234
>Correct Date: 0806171234
>
>Any ideas on how to change only the month portion of sql datetime field and then specifiy which month?

SELECT LEFT(Field,2)+RIGHT('00'+CONVERT(varchar(2),CAST(SUBSTRING(Field,3,2) as int)-1),2)+SUBSTRING(Field,5,10) As Test
FROM YourTable

not tested.