I have the following view that doesn't show the results when I use "like" criteria:

SELECT O_ord_pay.op_flag_1, O_ord_pay.op_flag_2, O_ord_pay.op_vendor;
 FROM dbbudget!o_ord_pay;
 WHERE O_ord_pay.op_flag_1 = 3;
   AND O_ord_pay.op_flag_2 = 4;
   AND O_ord_pay.op_vendor LIKE ?lc_ven

but, if I used the following:

SELECT O_ord_pay.op_flag_1, O_ord_pay.op_flag_2, O_ord_pay.op_vendor;
 FROM dbbudget!o_ord_pay;
 WHERE O_ord_pay.op_flag_1 = 3;
   AND O_ord_pay.op_flag_2 = 4

I get results in the vendor column showing text starting the letter with "A" (the text being AMERICAN FILE) but if I use the parameter with "like" criteria and then enter "A" for lc_ven prompt the results is an empty view. I know that we can do partial searchs on text in a column, but I am baffled why this is not working. Have I missed something here?

Thanks
Nick Patel
'