Received: from localhost.localdomain (IDENT:root@ppp18.linkey.ru [195.9.47.18]) by hub.org (8.10.1/8.10.1) with ESMTP id e7VH0xC44235 for ; Thu, 31 Aug 2000 13:00:59 -0400 (EDT) Received: from localhost (IDENT:karasiov@localhost [127.0.0.1]) by localhost.localdomain (8.9.3/8.9.3) with SMTP id VAA03609 for ; Thu, 31 Aug 2000 21:00:40 +0400 From: Sergei Karasiov Reply-To: karasiov@mediatech.ru Organization: MT To: pgsql-general@postgresql.org Subject: convert from access Date: Thu, 31 Aug 2000 20:51:02 +0400 X-Mailer: KMail [version 1.0.29] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <00083121004006.01123@localhost> Content-Transfer-Encoding: 8bit X-Archive-Number: 200008/801 I have to remake PHP script (which full of Access SQL implementation) for PostgreSQL. I have a some of strings like this: SELECT memmod.item, memmod.oempartno, memmod.sdescr FROM memmod WHERE (InStr(1, [item], '".$edtPartNo."'));"; How can I convert this string for PostgreSQL? -- ----------------- Sergei A. Karasiov serge@mediatech.ru