I have a form where I can enter, for example, AB-3456 into a field. Then when I click a command button I want all records to display that match the alpha-numeric portion . It should return those records like AB3456-1, AB3456-2, AB3456-3, AB-3456-1, etc.
How can this be done? In other words ignore the hyphens and just use the alpha-numeric.