Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
In and like
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
In and like
Miscellaneous
Thread ID:
00889397
Message ID:
00889397
Views:
49
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
Map
View

Click here to load this message in the networking platform