ms sql 2000 replace function

[coolT]

I'm trying to replace a certain string with another string in a text field using my ms sql 2000 database.

I use update TABLE set COLUMN = replace(COLUMN, OLD_VALUE, NEW_VALUE);

However, when I do this, my sql screams that the first variable in the replace function cannot be a string.

Anybody know a solution.

Thanks