update table_name set [content] = replace(cast([content]AS NVARCHAR(MAX)), '.pdf.pdf', '.pdf')
Monday, June 8, 2009
Argument data type ntext is invalid for argument 1 of replace function.
Subscribe to:
Post Comments (Atom)
update table_name set [content] = replace(cast([content]AS NVARCHAR(MAX)), '.pdf.pdf', '.pdf')
No comments:
Post a Comment