Another query question..

How would I write the query from this statement...

Select the item and item price of all items that start with S, P or F.

Here is the table structure...

items_ordered table
customerid
orderdate
item
quantity
price

I tried this..

select item, price
from items_ordered
where item like 'S%', 'P%', and 'F%'

...but I know that is wrong..

Thanks!
John Received on Sun Feb 24 2002 - 01:11:27 CET