Re: Query question

use
   Select * from my_table where my_field LIKE 'A%'

the % stands for *.

"Jorch" <jorch@saunalahti.fi> wrote in message
news:3A648758.71C69867@saunalahti.fi...
> 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"
>
>