I have a select statement in which the WHERE clause will be depends on an IN expression in which there are 8 elements in the IN () expression, but it looks like the IN only accept up to 6 arguments, for more than that it return an error:
Here my sample query:
where OrderStatus IN ("A", "B", "C", "D", "E", "F")
It works fine for the above statement but if I added "G", .... It does not work and give me an error message.
I check the Help file and found no thing saying any restriction on the IN expresion.
Any help in really appreciated.