The data type ntext of parameter 1 of the replace function in SQL is invalid.

After converting an ACC database to ms-SQL today, it is found that the replace statement is used:
The data type ntext of parameter 1 of the replace function in SQL is invalid. After searching for half a day, I found the solution:
Because ntext needs to be converted
Use the following statement to solve the problem:

Copy codeThe Code is as follows:
UPDATE table SET field = REPLACE (cast (field AS varchar (8000), 'replaced content', 'content to be replaced ')

Varchar (8000) is a field type. 8000 is a very fierce field, which can be changed according to your actual situation!