Thanks Cathi, that worked.
Nick Patel
>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
>>'