SELECT * FROM my_table WHERE my_field LIKE 'A%';
--rob
----- Original Message -----
From: "Jorch" <jorch@saunalahti.fi>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, January 16, 2001 12:39 PM
Subject: Query question
> How can I make query
>
> SELECT * FROM my_table WHERE my_field = 'A*';
>
> Meaning that I want to get all rows from my_table where my_field value
> begins with alphabet "A"
>
>
>