AnsweredAssumed Answered

Finding on a field with optional hyphens

Question asked by DavidVallance on May 31, 2012
Latest reply on Jun 1, 2012 by philmodjunk

Title

Finding on a field with optional hyphens

Post

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?

Outcomes