>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!


Try

SELECT * FROM dline WHERE INLIST(ALLTRIM(cde_tooth), '14', '1')