2009 R2 RTC DropDown Search question

ForeverBlue

Hi
When I try to do a search for the name of Sell-to Customer No. in sales order, I have to put *@ in the front of search string and a * at the end of it. Is anyway I can do programming or setup wise to enter a string, system will search anywhere in the field not just beginning and not case sensitive? :-k

Thanks

kriki

If I understood your problem well, this should help you:

SETFILTER("The Field",'@*xxx*');

ForeverBlue

What I want to do is to click on the drop down for sell-to Customer No., click on the name then enter a string. System search everywhere on the name of customer and not case sensitive. I thought about SETFILTER("The Field",'@*xxx*'); , but where will I put it in the page Sell-to Customer No. onlookup?? If that is the case, I have write more code for displaying the customer lookup page.

kriki

I checked it out and it already worked.
So I clicked the dropdown button and clicked name.
Than I entered "*ca" and I got all customers with ca in the name. It is case-insensitive.

So you don't need to add some code. It works out of the box.