Received: from indexapp00.indexc.net ([216.28.134.29]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA72989 for ; Tue, 16 May 2000 09:46:35 -0400 (EDT) (envelope-from twallingford@indexc.com) Received: by INDEXAPP00 with Internet Mail Service (5.5.2448.0) id ; Tue, 16 May 2000 09:46:03 -0400 Message-ID: <70866BD37E22D4119D8000600899F70D011C57@INDEXAPP00> From: "Wallingford, Ted" To: pgsql-sql@postgresql.org Subject: pattern matching operator Date: Tue, 16 May 2000 09:45:55 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200005/9 I need some help (the postgresql.org documentation pages are down??) I need to know what the pattern-matching operator is for string values in a select query... select field,field from table where field ?????? 'string'; I want to wildcard both ends of the string.. Thanks! Ted Wallingford