GetRecordIndexByNearKey

Databases
Aptilis 1

GetRecordIndexByNearKey(ArrayName[], Key, Index [, FromWhere])

GetRecordIndexByNearKey works exactly like getRecordIndexByKey except that it does an approximative search.
Here, I will just explain how to do the keys.
See getRecordIndexByKey for programming examples.
getRecordIndexByNearKey is not case sensitive.

GetAllRecordsByKey and GetAllRecordsByNearKey are more high-level and allow you to retrieve several records directly, in one go.

Examples
To do an aproximate search, use the special characters '?' for any one letter, and '*' for any group of letter.
"blue"will match 'blue', exactly.
"f*"All fields begining with 'f'.
"*i"All fields ending with 'i'.
"*a*"All fields containing the letter 'a'.
"?ree"All words of any first letter ending in 'ree', like 'tree' or 'free'.
"*a"Anything ending with the letter a, like 'ha' or 'armada'
etc...

Notes
The patterns used by 'GetRecordIndexByNearKey' are exactly the same as the ones used by Match.