Just figured that out! Thanks for everyones help!
>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!
"In three words I can sum up everything I've learned about life : it goes on." - R. Frost
Amanda Brown
Supervisor/Programmer