Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.
| |
E-mail
Sign In
SQL 2000:
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=367&lngWId=5
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=31893
http://www.sqlteam.com/article/search-and-replace-in-a-text-column
SQL 2005:
Update CompanyProfiles SET CompanyProfiles.CompanyProfile = REPLACE(CAST(companyprofile as varchar(max)),'A' ,'?') WHERE id_company = 12931
.NET Version:
http://equatorlive.com/blogs/dotnetdave/tech/sql-search-and-replace-on-text-type-columns/