Finding on a field with optional hyphens
I have a database which contains model numbers. Sometimes these model numbers have been entered with hyphens in them and sometimes without. I need to be able to find matching model numbers with and without eg. I want to find both SVT7 and SVT-7 with a single find. Logically I would assume that SVT*7 should work but it doesn't - it only finds the SVT7. Wildcards seem to work for every other variant except the hyphen so what am I doing wrong?