>I don't think I have ever noticed this, but
>if I say
>x = "_New"
>? inlist(UPPER(x),"NEW") && the result is .F.
>
>But if I say
>x = "New_"
>? inlist(UPPER(x),"NEW") && the result is .T.
>
>Shouldn't it be true for both cases????
Of course not.
inlist(a, b, c, d) means :
a = b OR a = c OR a = dFrom your question, it seems that you are expecting it to mean:
a $ b OR a $ c OR a $ dBut that is not the way INLIST() was designed.
>Set exact is OFF
>
>Thanks
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)