Is there a way you can find and replace words in sql? I need to replace certain chars within a couple of columns, !"£$%^&*()_+ etc and spaces with an underscore _

so for example, es.c0408.010 with es_c0408_010

Any help, as always is greatly received.

Stuart