tried that. It gave me blanks. Through some playing around, one of the other programmers found the SET ANSI ON command. That solved the problem! Although now I have to wonder how many things are wrong now because of that.... :)
Thanks!
>
>Try
SELECT * FROM dline WHERE INLIST(ALLTRIM(cde_tooth), '14', '1')
"In three words I can sum up everything I've learned about life : it goes on." - R. Frost
Amanda Brown
Supervisor/Programmer