Received: from access1.lan2wan.com (bmccoy@access1.lan2wan.com [205.177.8.10]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA66561 for ; Tue, 25 May 1999 16:23:54 -0400 (EDT) (envelope-from bmccoy@access1.lan2wan.com) Received: (from bmccoy@localhost) by access1.lan2wan.com (8.8.5/) id TAA20247; Tue, 25 May 1999 19:45:52 -0400 (EDT) Date: Tue, 25 May 1999 19:45:51 -0400 (EDT) From: "Brett W. McCoy" To: JT Kirkpatrick cc: "'pgsql-sql@hub.org'" Subject: Re: [SQL] using like In-Reply-To: <01BEA6CA.0ACA7E80.jt-kirkpatrick@mpsllc.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Tue, 25 May 1999, JT Kirkpatrick wrote: > ok, sorry for conjestion, but i figured it out: select autoinv, company > from table1 where company like '%Alice%'; -- that works in psql. but how > do i substitute "Alice" with a variable name?? A variable name where? In AccessBasic? Brett W. McCoy http://www.lan2wan.com/~bmccoy ----------------------------------------------------------------------- Never put off till tomorrow what you can avoid all together.