SQL Wildcards, Targeting a Record, Special Search, Specific, Field
February 08, 2013
How do I find a record where I am unsure of the spelling?
How do I find a record where I am not sure of the spelling?
We have a few undocumented ways to search for data in your database.
For this article I will use just the Last Name field. The techniques discussed here will work for any non-numeric field.
||returns all records greater than x
||>d, returns all names after CZZZZZZZZ|
||returns all records less than x
||<d, return all names before D|
||returns all records where this field is NOT BLANK
||returns all records where this field is ALL BLANK
||when used as the first character, will return any record that matches those characters that follow ANYWHERE within that field.
||%mund will return Amundsen, Adelmund, Aasmundrud, etc.|
How you would enter these is shown below:
The last example is especially useful when you don't know what the name begins with, but you at least know a few letters.
If you were looking for Kuehnemund and only heard it (not seen it), enter: %mund
The system will all names with 'mund' ANYWHERE within the name.