Hi George!

The following will work:

Replace: WHERE state IN ( ?vp_StateList )
With: WHERE state $ ?vp_StateList


>
>I am trying to create a view where the IN list is parameterized. For example, in this view the states are hard coded into the SQL statement:
>
>CREATE SQL VIEW lv_Sample AS ;
>SELECT lname, fname, customerid ;
>FROM test!customer ;
>WHERE state IN ('NY','PA','CA')
>
>I want to be able to pass a dynamic list as a parameter. Something like this:
>
>CREATE SQL VIEW lv_Sample AS ;
>SELECT lname, fname, customerid ;
>FROM test!customer ;
>WHERE state IN ( ?vp_StateList )
>
>vp_StateList = "'NY','PA','CA'"
>REQUERY('lv_Sample')
>
>vp_StateList = "'MA','OH','FL'"
>REQUERY('lv_Sample')
>
>
>How do I do this?
>
>TIA
>
>George