I have created a view and it works fine when I use one string as the variable Ex:

PASS1: Works Fine
lcPendCds = '73827282'
CREATE SQL VIEW tranmemo remote connection novtrans as SELECT * FROM tranmemo ;
WHERE ssFno = ?lcPendCds

When I add a few more parameters:

Pass2:
lcPendCds = " '73827282' OR '7627272' OR '8745949' OR '7376478' "
CREATE SQL VIEW tranmemo remote connection novtrans as SELECT * FROM tranmemo ;
WHERE ssFno = ?lcPendCds

The second pass blows up. Is there a why pass all of these parameters?