>Try instead of IN:
>SELECT DISTINCT ;
> Codes.type, Codes.code, Codes.subsystem ;
> FROM codes ;
> WHERE ","+ALLTRIM(STR(Codes.subsystem))+"," $ (?csubsystem)

Um, ok... that worked! Why? I'm using the view designer, how do I get it to use the $ instead of IN?