Removing quotation marks

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Mark (anonymous_at_discussions.microsoft.com)
Date: 09/14/04 

Date: Tue, 14 Sep 2004 12:21:52 -0700

I have data that is imported in with quotation marks
around each field in a record. Is there a way to write a
query that gets rid of the quotation marks? any help is
appreciated as always.
      How it is Desired
Field1 Field2 Field1 Field2
"ABC" "123" ABC 123