pick, match and fuzzy search?

[#1]

hii,

Whats is the difference between Pick and Match

What is Fuzzy search

Thank u in advance

Hita

[alexandros17]

Pick returns the nth expression in the list

pick(n, expr1[ , expr2,...exprN])

Pick( 2, 'A','B' ) returns B

Match compares strings and return yhe position of the one found

match( str, expr1 [ , expr2,...exprN ] )

Match( myField, 'Jan','Feb','Mar')  return 2 id myField is Feb

From Help:

Fuzzy search is similar to standard search, with the exception that it compares and sorts all field values according to their degree of resemblance to the search string. Fuzzy search is especially useful in situations where misspelling is an issue. It can also help you find multiple values that are nearly identical to each other.