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!

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.