An SQL primer
adsm> select typename,valuecount,remarks from enumtypes where not ((valuecount=3 or typename like 'O%') andremarks like '%t%')
TYPENAME VALUECOUNT REMARKS
------------------ ----------- ------------------
YESNO_TYPE 2 Yes/No Enumeration
LOGGINGMODE 2 Server logging
SEVERITY_TYPE 5 Message severity