Received: from camelia.wanadoo.fr (smtp-rt-10.wanadoo.fr [193.252.19.59]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA30160 for ; Sat, 3 Jun 2000 16:29:09 -0400 (EDT) (envelope-from T.J.Farrell@wanadoo.fr) Received: from mahonia.wanadoo.fr (193.252.19.58) by camelia.wanadoo.fr; 3 Jun 2000 22:29:03 +0200 Received: from oemcomputer (193.250.60.44) by mahonia.wanadoo.fr; 3 Jun 2000 22:29:02 +0200 Message-ID: <000601bfcd9a$c39f06e0$2c3cfac1@oemcomputer> From: "T.J.Farrell" To: Subject: LIKE vrs ~~ Date: Sat, 3 Jun 2000 22:31:07 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 X-Archive-Number: 200006/28 Hello, I was wondering about the performance incidence of : SELECT * FROM table1 WHERE UPPER(field1) LIKE UPPER('%thomas%'); versus: SELECT * FROM table1 WHERE field1 ~~ '%thomas%' if any...