Best approach to search a mixed field
I have a dataset of over a million rows.
One of the field contains data similar to these 2 formats;
123-456-789-01234
and
123-45678-90123
I need to build search page which return matches where the query may include the following scenarios:
45678
or
789
or
123
or
123-456-789 or 123-45678
Will the 'include' option in the search wizard satisfy these search examples?