Received: from falla.videotron.net (falla.videotron.net [205.151.222.106]) by hub.org (8.10.1/8.10.1) with ESMTP id e5MKEr162543 for ; Thu, 22 Jun 2000 16:14:53 -0400 (EDT) Received: from inter-resa.com ([24.200.227.43]) by falla.videotron.net (Sun Internet Mail Server sims.3.5.1999.12.14.10.29.p8) with ESMTP id <0FWK00AOINCOYH@falla.videotron.net> for pgsql-sql@postgresql.org; Thu, 22 Jun 2000 15:55:36 -0400 (EDT) Date: Thu, 22 Jun 2000 15:52:59 -0400 From: Web Manager Subject: Wildcard in date field??? To: pgsql-sql@postgresql.org Message-id: <39526E9B.418BB807@inter-resa.com> Organization: INTER-Res@ tourism network MIME-version: 1.0 X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.12 i386) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en X-Archive-Number: 200006/191 Hello, I need to make a query that will select items that have a date matching the current month for example. For June this means that any day between 2000-06-01 and 2000-06-30 are ok. To do that I need a wildcard like "%" to replace the actual day in the date field. Ex.: select * from item where date = '2000-06-%%'; but that doesn't work... What is the right way? Thanks! -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Marc Andre Paquin