Prompt , parameter and filter issue

[learnflower]

Hi ,

I have an issue which deals with all the 3 of  Prompt , parameter and filter .

I have products code which like AMPRTY , AMMAR i need to display in paramter only first 2 letters of it . this products are there in different branch so when i select checkbox as AM in the prompt it need to get all products starts from AM irrespective of the branch it is in .
I am giving subsrting(product_code,1,2) in ?product_code?

Please help me on this

Thanks in advance

[blom0344]

Can you please provide us with information about the part that does not work?

substring(product_code,1,2) in ?product_code?

would indeed fetch all codes starting with 'AM' when you use 'AM' as promptvalue