[thelist] SQL - Search & Replace?

Matthias Ritzkowski Matt at grndwtr.com
Fri Sep 21 10:41:13 CDT 2001


Why don't you code an ASP page to do that?

loop through all records and examine for the string "FOO", if you find it,
update that record with "FOO®"
Matthias


-----Original Message-----
From: J. Blanchard [mailto:jay.blanchard at thermon.com]
Sent: Friday, September 21, 2001 11:34
To: thelist at lists.evolt.org
Subject: [thelist] SQL - Search & Replace?


I had included this question in a reply yesterday to something else, but it
didn't get seen so...

I have a product called FOO which has a registered (®) mark, hence FOO®. Not
all mentions of FOO within the database have the ® but the powers-that-be
would like them to. Is there an search and replace functionality available
for SQL Server? I have searched documentation to no avail...





More information about the thelist mailing list