Update text in a NTEXT field

[ezfriend]

I have an Access application that allow user to replace text within a NTEXT field (SQL Express).

Unfortunately, I can't do the normal update

UPDATE tblDoc SET FieldName= REPLACE(FieldName, '; ', '|')

Any advice is truely appreciated.

-EZfriend.