General information
Forum:
Microsoft SQL Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only