Thread: RE: [INTERFACES] Re: LIKE clause

Never mind got it

WHERE name LIKE 'A%'

Tom

 -----Original Message-----
From:     Thomas Byrnes [mailto:tbyrnes@helioshealth.com]
Sent:    Monday, October 25, 1999 12:04 PM
To:    'pgsql-interfaces@postgresql.org'; 'pgsql-general@postgresql.org'
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?

Thanks much,

Tom

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