-----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%'