"run q_columns TABLE" as in "run q_columns actlog" shows you all the variables that are available in a given table. So the select you want, without any special formatting added, is "tsm: ULTSM>Select date_time, msgno, message, nodename from actlog Where msgno in (4952, 4954, 4957)
>>> "Lee, Gary D." <[EMAIL PROTECTED]> 11/9/2006 11:03 AM >>> I want to select only a subset of messages from the activity log table. For instance, Select datetime, msgno, message, nodename from actlog Where messages in (4952 4954 4957) Etc. Just looking for some syntax help. Don't currently have a good sql manual. Tia for any help. Gary Lee Senior System Programmer Ball State University
