Update Partial Field

[DonP]

I haven't used SQL Server in several years and have forgotten how to do a simple thing. Can someone refresh my memory of how to update a part of a field while leaving the rest of the same field as it is? In this case, the field contains a URL and I need to change only the domain name. Thanks.

Don

http://www.pc-homepage.com/

http://www.personalzone.net/

Experienced in HTML, Perl, PHP, VBScript, PWS, IIS and Apache and MS-Access, MS-SQL, MySQL databases

 

[SQLDenis]

update table1
set field =replace(field,'OldDomain','NewDomain')
where field like '%OldDomain%'

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[DonP]

Thanks a bundle! It worked like a charm.

Don

http://www.pc-homepage.com/

http://www.personalzone.net/

Experienced in HTML, Perl, PHP, VBScript, PWS, IIS and Apache and MS-Access, MS-SQL, MySQL databases