如何修剪sql中某些字符后的所有内容

I am trying to format the email address in my table by removing everything starting the @. Also I would like to replace the underscore with blank space. I am trying to format the email address in my t