hello, I have successfully changed an ModuleID Column with this script: Update dbo.C5SLLC_FormData Set ModuleID = '383' Where ModuleID = '1090' but when I use it to change some text in another column with the same script, for example from 'tree' to 'three', I have an error. Any help is apreciate. regards

What is the error?

this is the error:

'The data types ntext and varchar are incompatible in the equal to operator error.'

Assuming you're on SQL 2005 or 2008, it sounds like you need to convert the ntext column to nvarchar(max) to work with it (so replace "colname" with "CONVERT(nvarchar(max), colname)". If you still have trouble then please post the failing SQL statement.

Thank you Mark!
I have used this script:

ALTER TABLE dbo.C5SLLC_FormData ALTER COLUMN FormData NVARCHAR(MAX) null

and next, this script:

UPDATE dbo.C5SLLC_FormData
SET FormData = Replace(FormData,'old-word','new-word')

I have modified some 'bad' text in a column..