When setting the lc_ven variable, set it to "A*". The like clause will match any records that start with an A.

>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
>'