How do you replace characters as in an update?
Example I have an address field that contains '.' and '-' and I need to remove these characters.
Anyone know of an update script to do so?
moone009
0
Junior Poster in Training
Recommended Answers
Jump to PostDid you RTFM? http://msdn.microsoft.com/en-us/library/ms186862.aspx
Looks pretty straightforward
update [tablename] set [fieldname] = replace([fieldname],'.','')Probably want to verify those results with a select before you run the update though.
All 2 Replies
Ezzaral
2,714
Posting Sage
Team Colleague
Featured Poster
Did you RTFM? http://msdn.microsoft.com/en-us/library/ms186862.aspx
Looks pretty straightforward
update [tablename] set [fieldname] = replace([fieldname],'.','')Probably want to verify those results with a select before you run the update though.
moone009
0
Junior Poster in Training
Awesome! Definitely appreciated!
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.