Query problem

[James McIver <McIverJ@xxxxxxxxxxxxxxxxxxxx>]

I have a library containing CMDs and PNLGRPs (associated help files).  What
I want to do is get a query tell me which commands do not have help files.
All the panel groups have the name of the command in the text field.
I have tried doing a wrkobjd to outfile for both CMD and PNLGRP, but I have
got lost on the syntax.
I tried select odobnm from qtemp/cmd where odobnm in (select odobtx from
qtemp/pnl) - but surprise, surprise, it didn't work - probably because the
odobnm field is 10 long, but the odobtx is 50 long.
I really need something similar to LIKE, but I can't see how to fit it in!

Secondly, I saw a reference recently to the archives - How does one access
them?

Jim
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---