标签归档:Search

Search and Replace in a TEXT(NTEXT)

MSSQL: Search and Replace in a TEXT(NTEXT) columnIt’s been a while since I’ve posted anything SQL related. So… 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. 继续阅读