Category Archives: SQL Queries

SQL Query Replace Error – Argument data type ntext is invalid for argument 1 of replace function.

This means yr column/field could be a Text or Ntext, to get around it you would have to cast the field/column to an nvarchar(max) REPLACE(cast([MyColumn] as nvarchar(max)),’ReplaceWord’,’ToThisWord’) to do a test before you really update the database use this SELECT … Continue reading

Posted in SQL Queries | Leave a comment