Received: from jupiter.hub.org (jupiter.hub.org [64.49.215.5]) by postgresql.org (Postfix) with ESMTP id B48204758A1 for ; Sat, 9 Mar 2002 03:34:59 -0500 (EST) Received: (from news@localhost) by jupiter.hub.org (8.11.6/8.11.6) id g297pqL58632 for pgsql-sql@postgresql.org; Sat, 9 Mar 2002 01:51:52 -0600 (CST) (envelope-from news) Lines: 6 X-Admin: news@aol.com From: jdou12345@aol.com (Jdou12345) X-Newsgroups: comp.databases.postgresql.sql Date: 09 Mar 2002 07:51:32 GMT Organization: AOL http://www.aol.com Subject: Retrieving a ' in an SQL statement? Message-ID: <20020309025132.11876.00000776@mb-dh.aol.com> To: pgsql-sql@postgresql.org X-Archive-Number: 200203/145 X-Sequence-Number: 7025 Hi, I need to know if there is any way to pull a record into a recordset which contains a hyphen( ' ) when using an SQL statement. I am using sql statements to query an Access 2000 database. ANy help would be greatly appreciated.