SELECT * FROM my_table WHERE my_field LIKE 'A%';
Should do it!

> -----Original Message-----
> From: Jorch [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 16, 2001 5:40 PM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] 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"
> 
> 

Reply via email to