Description
Use this function whenever you want to locate records based on two or more field values that are spelled differently yet look alike. The function returns True if the string matches the mask and False if the string does not match the mask.
Arguments
string is the text string or field containing text string values that are being compared to the mask.
mask is a text string that provides a mask for comparing the value in the string argument.
Action
Enables you to locate field values using a standard DOS wildcard (? = wildcard for single character, * = wildcard for any number of characters). It does this by comparing a string to a mask that contains one or more wildcards. The function returns True if the string matches the mask and False if the string does not match the mask.
Typical uses
Use this function whenever you want to locate records based on two or more field values that are spelled differently yet look alike (have an essentially similar structure).
Examples
LooksLike ("Snyder","Sn?der")
Returns TRUE.
LooksLike ("Schneider","S?der")
Returns FALSE.
LooksLike ("Schneider", "S?????der")
Returns TRUE.
If LooksLike ({customer.CONTACT FIRST NAME},"?ris" Then
{customer.CONTACT FIRST NAME}
Else
""
Returns Cris, Kris, and Iris, but not Chris (assuming all of these values are in the {customer.CONTACT FIRST NAME} database).