Lets say I have a field in an SQL Server 2000 table with 20 fields. In one field, called Field1, I have entries such as:

November2010\Grocery\Apples
November2010\Grocery\Oranges
November2010\Grocery\Grapes
November2010\Grocery\Bananas
etc

I want to replace November2010 in that field while leaving the existing text "\Grocery\Whatever" in place.

I tried
Code:
select field1 replace('November2010','November2010','December2010') from tablename
But it gives me a snytax error near 'November2010'