Re: [SQL] using like

Brett W. McCoy <bmccoy@lan2wan.com>

From: "Brett W. McCoy" <bmccoy@lan2wan.com>
To: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
Cc: "'pgsql-sql@hub.org'" <pgsql-sql@hub.org>
Date: 1999-05-25T23:45:51Z
Lists: pgsql-sql
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.