[RESOLVED] Replacing Text In SQL Server 2000 Field

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'

Try this:

Code:

---

select replace(field1, 'November2010', 'December2010') from tablename

---

That ran without errors and listed out that specific field with December2010 as the first part of the entry rather than November2010.

However, when I then did a SELECT * FROM tablename, the field still had November2010 in it. :confused:

Do I need to do a Commit?

That is just a Select statement Hack. If you want to update the database field you need to Run Update
right

Every example of the REPLACE function that I found used SELECT, so that is what I did.

However, this worked splendidly

Code:

---

update tablename set field1 = replace(field1, 'November2010', 'December2010')

---

Thanks.