One of the really nice commands available in SQL is the IN command. If you're unfamiliar with SQL, IN is a command that takes a list of parameters (between 2 and . . . well . . . I don't know if there is a limit) and returns true if the requested value exists in the list specified by those parameters. A simple example using interactive SQL (the STRSQL command) might be as follows: SELECT PET_NAME WHERE PET_TYPE IN('Dog','Cat','Iguana') In this example, SQL returns a result set ...

REGISTER NOW TO ACCESS THIS ARTICLE

All registered users get access to premium content on iPro Developer for free.

Already registered? here.