Anatoly Lubarsky

Logo
MSSQL, .NET, Design. Life and Music

Saturday, May 03, 2008

MSSQL: Search and Replace in a TEXT(NTEXT) column

Sometimes we need to search and replace a text value in the entire table. The column in question is of TEXT or NTEXT datatype. T-SQL REPLACE function does not work with TEXT/NTEXT datatype. Instead we have to use several other functions [ ... ]

posted @ 8:16 PM | Your thoughts (0)