# 413 The SQL IN Operator is Not Working Properly for International Settings and Integers

---

The IN()-Clause is comparing against an INTEGER-Field so it does not work here for more than one Integer-number.

Select * from test where id IN (1,2,3)

I get an error in DBSYS utilty -> '1,2,3' is not a valid floating point value but the field id is of type integer.