• Write an Update statement with REPLACE(column,'"','') for each column.

    That replace is: REPLACE ( column, ' " ', ' ') in case you can't really read it.

    Seth Phelabaum


    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]