Hi Amanda,

SET ANSI is the setting for SQL, but I think, you should just use the second SQL, e.g.
SELECT * from ... where INLIST(myField,"MyVal1","myVal2")..., where myVal1 and myVal2 have length of the field, e.g. "padred" with necessary number of spaces.

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