You have several "wild card" operators you can use once you learn how they work.
* , for example is a wildcard that stands for "any number of characters, don't care what they are".
If you enter *78 to use your example, you can find all records where the field ends in the digits 78.
Searching on the serial ID seems to be a strange sort of search. Shouldn't you be searching more meaningful fields than just a serial number?
Thanks! We do have a lot of other fields to search in, but the serial number is a good reference as we have a unique number for every photo we are storing in this database (I work in documentary film). The serial number acts as an ID and so it's an easy way to refer to and find one specific photo in what will probably be tens of thousands. I guess I'm lazy because sometimes I don't want to have to type in the whole number every single time, and I was hoping there was a setting I could use to get multiple results based on partial information... probably because that's how I use google.
Anyway, thanks for your help!