Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA69377 for ; Tue, 25 May 1999 16:36:51 -0400 (EDT) (envelope-from jt-kirkpatrick@mpsllc.com) Received: from kirkpatrickjt (whiteoak-34.highertech.net [209.140.56.34] (may be forged)) by s20.highertech.net (8.8.6/8.8.6) with SMTP id QAA08253; Tue, 25 May 1999 16:35:49 -0400 Received: by localhost with Microsoft MAPI; Tue, 25 May 1999 16:37:49 -0400 Message-ID: <01BEA6CC.ECE7B560.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'Brett W. McCoy'" , JT Kirkpatrick Cc: "'pgsql-sql@hub.org'" Subject: RE: [SQL] using like Date: Tue, 25 May 1999 16:37:46 -0400 Organization: MPS, LLC X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit ahh, sorry again for conjestion on the list! i have parameter criteria defined in an msaccess97 query, so when i run the query, it asks me for a value. i since learned that i can put those wildcards (%) in the value i type in when access asks for it! also, in the query definition (access97, not a passthrough. . .) i can also convert the field to uppercase and convert the user-input value (criteria expression) to uppercase so the search isn't case-sensitive! it just gets cooler. . . jt -----Original Message----- From: Brett W. McCoy [SMTP:bmccoy@lan2wan.com] Sent: Tuesday, May 25, 1999 7:46 PM To: JT Kirkpatrick Cc: 'pgsql-sql@hub.org' Subject: Re: [SQL] using like 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.