SET ANSI Command determines how comparisons between strings of different lengths are made with the = operator in Visual FoxPro SQL commands. See help for details.
>Hi all!
>
>My problem with inlist() is .... well here's an example
>
>Select * from dline where inlist(cde_tooth, '14', '1')
>
>I get any tooth code that starts with a 1. I did some searching here on UT and found the solution of SET EXACT ON. So, I tried that. Didn't work.
>
>The cde_tooth field is c(2). And if I modify my code to
>
>Select * from dline where inlist(cde_tooth, '14', '1 ')
>
>then I get the correct results, just 14's and 1's. That shouldn't be like that though, should it? Maybe I'm missing something....
>
>
>thanks in advance!
--sb--