Reputation: 61
How to remove single Quote from given select Query. It is give me Conversion failed when converting the varchar value '1,2,3' to data type int.
SELECT * FROM Member
WHERe MemberId IN ('1,2,3')
Upvotes: 2
Views: 42
Reputation: 18747
You don't have to use single quotes for integer field:
SELECT * FROM Member WHERE MemberId IN (1,2,3)
You should use quotes for varchar fields, like:
SELECT * FROM Member WHERE Name IN ('John','George','Amanda')
Upvotes: 4