TRIM unwanted chars from string in SQL

It's pretty simple but I didn't know this:
TRIM('.,! ' FROM '# test .')