"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." <GLEE AT BSU DOT EDU> 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