Re: [INTERFACES] Re: LIKE clause

-----Original Message-----
From: Thomas Byrnes <tbyrnes(at)helioshealth(dot)com>
To: pgsql-interfaces(at)postgreSQL(dot)org <pgsql-interfaces(at)postgreSQL(dot)org>;
pgsql-general(at)postgreSQL(dot)org <pgsql-general(at)postgreSQL(dot)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%'