10774: alternatives to the OR sentence
Posted on 2014-11-20
i have this query
/****** Script for SelectTopNRows command from SSMS ******/
where city = 'Tokyo' OR city = 'Osaka' OR city = 'London'
The user may enter 1, 2, 3 or n city to do the search. I understand that using OR is not advisable, so as I can do?