I am not sure where to ask this question.
I have a table called parts
a field in that table called part number, this is a text field
The part number from my suppliers can be any format ie;
245-678-00, 8W-957, 89 07 68, 568.897.RB
When some one enters a new part if they do not get the - . or the spaces in the correct places it is impossible to locate the part in a search. It is also possible to enter the same part number 2 x with different format
Is there a way to save and look up only the values and not the - . or spaces no mater what the user inputs.
I have a table called parts
a field in that table called part number, this is a text field
The part number from my suppliers can be any format ie;
245-678-00, 8W-957, 89 07 68, 568.897.RB
When some one enters a new part if they do not get the - . or the spaces in the correct places it is impossible to locate the part in a search. It is also possible to enter the same part number 2 x with different format
Is there a way to save and look up only the values and not the - . or spaces no mater what the user inputs.