Knowledge Base
User:
Password:
|
Article ID | : |
KB80 |
Keyword Name | : |
SQL Wildcards, Targeting a Record, Special Search, Specific, Field |
Created | : |
February 08, 2013 |
Viewed | : |
10672 |
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.
Operator |
Result |
Example |
> |
returns all records greater than x |
>d, returns all names after CZZZZZZZZ |
< |
returns all records less than x |
<d, return all names before D |
/n |
returns all records where this field is NOT BLANK |
|
/b |
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:
![](http://www.trailblz.com/kb/images/kb0080/fuzzysearchexamples.png)
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.
|