Padding Record Field
I want to make it so that if someone attempts to search for a position number of "45" in a search record, that it auto-populates the search with "00000045" in an attempt to make searching for position numbers easier. What is the best solution to this problem?