5Star
5Star

Reputation: 61

Sql Server IN Clause

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

Answers (1)

Raging Bull
Raging Bull

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

Related Questions