AnsweredAssumed Answered

How do you perform searches with & without leading zeroes?

Question asked by bradleyboggs on May 13, 2014
Latest reply on May 14, 2014 by mikebeargie

Hi there and thank you in advance for your help!


I'm having trouble performing searches when Leading Zeroes are involved.


Example: If my PO Number is entered as 0420339608 because thats how it was formatted on an order, and then the customer calls and doesn't give us the leading Zero (i.e. asks about order "420339608"), when we perform a find in the database nothing comes up.


Currently this field is set to Text as many of our PO numbers are Alphanumeric.


Is there something I can do that will find "0420339608" even if you search for "420339608"? Our clients aren't consistent so I can't tell our staff or set a rule to skip/omit leading zeroes altogether.


Currently the user clicks a button to go to the "Find order" screen/layout and enters Find Mode, has 10 or so fields they can enter information in. From there, there's a button/script that performs the find and takes them to a specific layout depending on their privelege set.


Currently I just have a "Perform Find" script step with no finds in it (since the screen is already in Find Mode).