Need help on IN statement.

Last Post 08 Mar 2004 09:47 AM by ConKi. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ConKi
New Member
New Member

--
08 Mar 2004 08:39 AM
Hi all,

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:
select *
from Orders
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.

ConKi.


ConKi
New Member
New Member

--
08 Mar 2004 09:47 AM
Hi rm,

I rerun the query and it works now. It should not have any limitations of the number of item inside the ().

Thank you,

ConKi.
You are not authorized to post a reply.

Acceptable Use Policy