[GENERAL] Re: Query question

[Gregory Wood]

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 want to get all rows from my_table where my_field value
 begins with alphabet "A"
 
 

[GENERAL] Re: Query question

[Michael J Davis]

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 alphabet "A"

[GENERAL] Re: Query question

[rob]

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 want to get all rows from my_table where my_field value
 begins with alphabet "A"