SQL Update Query - Replace Text

I am trying to replace a string in a text field, but I am getting an error.

Error:
Argument data type ntext is invalid for argument 1 of replace function.

UPDATE    Pages
SET              PageInfo = REPLACE(PageInfo, 'http://beta.mywebsite.com/lakota/', 'http://www.yahoo.com/')
WHERE     (PageInfo LIKE '%http://beta.mywebsite.com/lakota/%')

Please advise on how to replace a string within a text data type field.  I do not want to replace the whole text field - justa portion of it..

Thank you!Start Free Trial