Use the following format to perform inexact matching:

If you want to extend a key field, use any number as the

Field ID

value. If you do not want to extend any key field, use 0 as the

Field ID

value. If you extend a key field in the search or file data, you must extend the corresponding key field in the search or file data.

The value

B

indicates a null value, the value

Z

indicates a zero value, and the value

ZB

indicates a null or zero value.

The following sample expressions perform inexact matching between the search data and file data values:

PURPOSE=Person_Name SEARCH=Person_Name(!Exact),0,16 FILE=Person_Name,0,16
. The expression returns 100% score if the search data value does not match with the file data value.
PURPOSE=Fields SEARCH=Person_Name(1;5;!Exact),0,16 FILE=Person_Name(1;!Exact),0,16
. The expression creates an extended field for the
Person_Name
field named
Person_Name(1)
and sets the weight for the extended field to 5. The search data value returns 100% score if the search data value does not match with the file data value.
PURPOSE=Person_Name SEARCH=Person_Name(0;5;!Exact),0,16 FILE=Person_Name,0,16
. The expression sets the weight of the
Person_Name
field to 5 without creating any extended field. The search data value returns 100% score if the search data value does not match with the file data value.
PURPOSE=Fields SEARCH=Person_Name(3;!Exact),0,16 FILE=Person_Name(3;!Exact),0,16
. The expression creates an extended field for the
Person_Name
field named
Person_Name(3)
, and the extended field uses the weight of the
Person_Name
field. The search data value returns 100% score if the search data value does not match with the file data value.
PURPOSE=Fields SEARCH=Date,0,8 FILE=Date(!Exact:ZB),0,8
. The expression returns 100% score if the file data value is not 0 or null.