I have a data extension where values are imported via an Import Activity. One of those values is a URL ending in .biz. I'm trying to write a query that finds all instances of .biz with .com but encounter an error saying:
"An error occurred while checking the query syntax. Errors: Only SELECT queries are valid. Select must be the first word of the query."
Here's what I wrote:
UPDATE [DataExtension_A] SET LinkURL = REPLACE(LinkURL, 'www.url.biz', 'www.url.com')
Is there some other way to find and replaces values in a data extension or is this not possible?