...
where carrier_name LIKE 'ALLTEL%' 
         OR carrier_name LIKE 'Ameritech%'

>Hi All:
> I want to combine in and like function together in one statement. Like so:
>
>Select carrier_name from carrier where carrier_name like in('ALLTEL%','Ameritech%')
>I get an error. The error is: Line 10: Incorrect syntax near ','.
>How can I combine the in and like functions?
>Thanks
>MA