Wildcard Search on numbers

jthompson

Can you do a wildcard search on part of a number in a custom text field? Example, I have a Reference field with values such as CR1234. User is trying to narrow down and search by this reference number - the advanced search using wildcard *1234 does not work. Has anyone had luck searching on parts of a field data that contains numbers? 

Payne

Sure, you can search for numeric strings just as well as alpha strings. However, with any string, you cannot use a wildcard at the beginning (e.g. *1234 is not allowed, but 1234* is allowed). If you know the prefix of your reference number, you can use it (e.g. CR123*), but like I said, *1234 will not work.