如何从列的值中删除双引号?

这是表格，每一列的值都用双引号()括起来.

Here is the table, each column value is wrapped with double quotes (").

Name    Number      Address Phone1  Fax Value   Status
"Test"  "10000000"  "AB"    "5555"  "555"   "555"   "Active" 

如何去除每一列的双引号?我为每一列都试过这个:-

How to remove double quote from each column? I tried this for each column:-

UPDATE Table 
SET Name = substring(Name,1,len(Name)-1) 
where substring(Name,len(Name),1) = '"'

但正在寻找更可靠的解决方案.如果任何列有尾随空格，这将失败

but looking for more reliable solution. This fails if any column has trailing white space