G
Guest
While passing multiple comma separated values to select query with In
operator, the query doesn't return any rows.
I.e Following query gives me reuquired resultset
Select * From Emp Where EmpName in ('Sid','Dev','Das')
But when I pass EmpNames = "'Sid','Dev','Das'", it doesn't return me any
result
Select * From Emp Where EmpName in (EmpNames)
operator, the query doesn't return any rows.
I.e Following query gives me reuquired resultset
Select * From Emp Where EmpName in ('Sid','Dev','Das')
But when I pass EmpNames = "'Sid','Dev','Das'", it doesn't return me any
result
Select * From Emp Where EmpName in (EmpNames)