Received: from ip.eth.net (mail2.ip.eth.net [202.9.128.19]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB746Dm26143 for ; Thu, 6 Dec 2001 23:06:15 -0500 (EST) (envelope-from sharmad@goatelecom.com) Received: (apparently) from punweb01 ([10.1.1.14]) by ip.eth.net with Microsoft SMTPSVC(5.5.1877.467.46); Fri, 7 Dec 2001 09:36:11 +0530 From: sharmad@goatelecom.com Reply-to: sharmad@goatelecom.com To: pgsql-sql@postgresql.org Date: Fri, 7 Dec 2001 09:36:50 +0550 Subject: Replacing "LIKE" with "=" X-Mailer: DMailWeb Web to Mail Gateway 2.7q, http://netwinsite.com/top_mail.htm Message-id: <3c10405a.6b0.0@punweb01> X-User-Info: 61.1.72.174 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Archive-Number: 200112/97 X-Sequence-Number: 5920 Can I replace a query statement having a "LIKE" with a statement having "=" still getting the same functionality Like for ex:- SELECT * from teble_name WHERE name LIKE "%name%"; Keeping in mind the output of the query i want to replace this query with a statement having "=" and no more "LIKE" TIA -Sharmad