Received: from eidolon.entheal.com (IDENT:root@cc13519-a.owml1.md.home.com
	[24.6.134.154]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA33239;
	Mon, 25 Oct 1999 14:42:54 -0400 (EDT)
	(envelope-from jacob-christen@home.com)
Received: from jchristen ([204.240.195.21])
	by eidolon.entheal.com (8.9.3/8.9.3) with SMTP id OAA00904;
	Mon, 25 Oct 1999 14:45:27 -0400
Message-ID: <000a01bf1f18$8fa7fad0$4a0b030a@jchristen.educate.com>
From: "Jacob Christen" <jacob-christen@home.com>
To: <pgsql-interfaces@postgreSQL.org>, <pgsql-general@postgreSQL.org>
Subject: Re:  [INTERFACES] Re: LIKE clause
Date: Mon, 25 Oct 1999 14:13:46 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

-----Original Message-----
From: Thomas Byrnes <tbyrnes@helioshealth.com>
To: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>;
pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>
Date: Monday, October 25, 1999 1:56 PM
Subject: [INTERFACES] Re: LIKE clause


>Alright, it seems simple enough, but I am having no luck figuring out the
>syntax for the LIKE clause.
>
>I have tried: WHERE name LIKE 'A*' and other similar combinations to no
>avail. Anyone have any suggestions?


you're using the wrong wildcard character.

try:

SELECT name FROM my_table WHERE name LIKE 'A%'