using like - Mailing list pgsql-sql

From JT Kirkpatrick
Subject using like
Date
Msg-id 01BEA6C9.7A523DC0.jt-kirkpatrick@mpsllc.com
Whole thread Raw
Responses Re: [SQL] using like
List pgsql-sql
i'm trying to query my database (6.4.2 through odbc ms access) to find all 
records matching a "like" statement.  from psql i am trying this -- select 
autoinv, company from table1 where company like 'Alice'; -- but it doesn't 
work!  i could run whatever works in psql as a passthrough query in 
access97, if i could get it to work in psql!  i'd expect the query to pull 
values of company that = "Alice w." "Alice Higgins" "Alicexxxxxxx" 
"xxxxAlice..xxx", and you get the idea.

TIA for any help!  jt


pgsql-sql by date:

Previous
From: "D'Arcy" "J.M." Cain
Date:
Subject: Re: [SQL] Stupid SQl question on inserting items
Next
From: JT Kirkpatrick
Date:
Subject: using like