Find in a text field: Why finds Root.pdf but not Root2.pdf?
I just don't get this logic, and I don't understand how to explain to others how to find what they need in our database!
We have a file with thousands of records. We're searching a text field called "Image Filename". We have these three records:
Someone was trying to find all image names with an extension of .pdf. We've always thought using asterisks on both sides of the find request would get you every match possible, no matter what surrounded the string to be found. So I told them to search for
...Only the first two came up! Searching for
.pdf (dot pdf, no asterisks)
...only bought up TreeRoot2.pdf.
pdf (plain old stand-alone pdf)
...also brought up only TreeRoot2.pdf
Could someone explain the logic? Seems like I have to let go of my idea of "when in doubt, surround the find string with asterisks"...
How to find all images with an extension of .pdf??