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?
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?
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.
Awesome! Definitely appreciated!
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.