Need to Pass multiple string value in like operator

Sonu Gupta7y ago

Hi,

Check the following links -

1. https://dba.stackexchange.com/questions/170579/select-multiple-values-in-like-operator

2. https://stackoverflow.com/questions/1387612/how-can-i-introduce-multiple-conditions-in-like-operator

0

Rajanikant Hawaldar7y ago

Hi Kumar, This is best solution for your issue, go through this article. https://www.c-sharpcorner.com/blogs/passing-multiple-parameters-in-sql-in-clause-with-sqlcommand Thanks

0

Amit Mohanty7y ago

Try this

SELECT * FROM TEST WHERE CODE LIKE 'E4%' OR CODE LIKE 'N7%'

You can't use LIKE operator like this where Code Like ('E4%', 'N7%')

0