passing variables in stored procedures

I am working in Informix 7.2 and I have two question. Queston - 1: I have a stored procedure that accepts 4 variables. two characters and two integers. The second character is State code. Part of the new modifications to the report is to allow the end user to select multiple state codes, for example FL, GA, AL, MS. I would like to know how I could go about coding to allow the stored procedure to accept this dynamic string and equate it in the stored procedure 'where clause' to read ...WHERE state_code IN ('FL', 'GA', 'Al', 'MS')... Question - 2: Assuming there is no solution to question 1, here is the second one: How do I parse the above string into individual variables, in a temp table? -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own