Allen, I am from a Unidata background. I am guessing that you work in Universe? I am curious about how Universe works.
>> as only one WHEN per statement works. Does that mean you can only use one WHEN verb in a SELECT statement? In Unidata you can use multiple WITH (OR WHEN) verbs in a statement. Example. SELECT WIP-BATCH-DETAIL-HIST_MA WITH WORK.DATE >= "10/1/07" AND WITH WORK.DATE <= "10/31/07" I believe it was the same in the old PICK days. Anyone remember Ultimate PICK? It was OK, but it didn't live up to its name. Charles Shaffer Senior Analyst NTN-Bower Corporation ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/