Closest match

[Amit Galanty]

Hii all,

I am trying to use the Match function. 

When the function gets a string it finds the first match in the database that satisfies the threshold limitation.

Is there a way to find the closest match instead of the first match without lopping the threshold values?

Thanks, Amit.