> I need to extract from a table the words that *Start* with
> specific letters - more than one.  i.e. select all those words
> that start with B or D or F.

> SELECT FirstName, LastName FROM People Where LastName  ***LIKE A
> or B or C ****    ORDER BY FirstName"

>> I need to extract from a table the words that *Start* with
>> specific letters - more than one.  i.e. select all those words
>> that start with B or D or F.

>[snip]

>> SELECT FirstName, LastName FROM People Where LastName  ***LIKE A
>> or B or C ****    ORDER BY FirstName"

>SELECT FirstName, LastName FROM People Where LastName  LIKE 'A%'
>OR LastName LIKE 'B%'
>OR LastName LIKE 'C%'

>ORDER BY FirstName

>That should work.
>Ive tested the sql statement on an oracle 8.0.5 and got all names starting
>with A or B

>Greetings from germany
>Dirk