SQL with bunch of or clauses

Question

Trying to get the result with a bunch of or clauses.

SELECT * FROM SA15B WHERE PoNo In (6801398832,6801397033,6801397605,6801393990,6801398301,6801397424,6801398020,6801393991,6801398302,6801397425,6801395049,6801395050,6801394454,6801397707,6801397703,6801395197)

Answer 1

Trying to get the result with a bunch of or clauses.

Read the error message; has nothing to do with the "OR" clause.

Values are stored as "nvarchar" = string/text, you query it as it would be a numeric; of cause the could fail.

And "6,801,258,182" is much above the number range for integer = -/+ 2 G.

Query string as string =>

SELECT * 
FROM SA15B 
WHERE PoNo In ('6801258182');

Answer 2

Solved with help

SELECT * FROM SA15B WHERE PoNo IN ('6801398832','6801397033','6801397605','6801393990','6801398301','6801397424','6801398020','6801393991','6801398302','6801397425','6801395049','6801395050','6801394454','6801397707','6801397703','6801395197')