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 that I
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 with
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*';
Meaning that I