SELECT * FROM my_table WHERE my_field LIKE 'A%';
--rob
- Original Message -
From: "Jorch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 16, 2001 12:39 PM
Subject: Query question
> How can I make query
>
> SELECT * FROM my_table WHERE my_field = 'A*';
>
> Meanin
select * from my_table where my_field like 'A%';
"Jorch" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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 w
SELECT * FROM my_table WHERE my_field LIKE 'A%';
Greg
- Original Message -
From: "Jorch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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