Global Search&Replace Text in all fields in sql db

		Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Global Search&Replace Text in all fields in sql db

SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Page 2 of 2

September 14th, 2006, 08:24 AM

dparsons

Wrox Author

Join Date: Oct 2005

Posts: 4,104

Thanks: 1

Thanked 64 Times in 64 Posts

That function should work fine on nvarchar and varchar fields, TEXT fields are just...funny for lack of a better word.

"The one language all programmers understand is profanity."

Page 2 of 2

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Search and Replace a text in XML file	AyatKh	XML	17	May 23rd, 2012 09:05 PM
How to replace db column name with Global variable	nesrine	C#	0	March 5th, 2007 10:06 AM
How can i replace db column name with Global varia	nesrine	ASP.NET 2.0 Professional	0	March 5th, 2007 10:05 AM
replace fillin with ask fields & add references	mariatherp	Beginning VB 6	1	December 15th, 2004 06:12 AM
RTF Search & Replace	PC User	Access	0	June 16th, 2004 01:46 PM