Please can someone validate that
WHERE Wildmatch(field, condition)
WHERE Wildmatch(field, condition) >0
To be safe, I always explicitly test for >0, but by I accidently discover that omitting yield the same result.
Yes both are same
If return value of Wildmatch is zero, which is equivalent to false
If return value of Wildmatch is greater than zero, which is equivalent to true
Both are acceptable.
WildMatch(Field, Condition1, Condition2, Condition3) return respectively 1,2,3 etc if condition is true.
In QV False=0, other - TRUE
Hope this helps.
Retrieving data ...