Hello again,

I'm using AREV 3.12 and I'm trying to use the BETWEEN…AND clause from the TCL. In addition, I'm trying to link several of them together using OR statements. However, it only seems to be evaluating my first BETWEEN clause and ignoring all of the others.

I'm generating the statement through code, and the final statement has the following form:

SELECT WITH DATE BETWEEN '01/11/99' AND '01/25/99' OR WITH DATE BETWEEN '12/14/98' AND '12/28/98' OR WITH DATE BETWEEN '11/16/98' AND '11/30/98'

I've tried modifying it by using parentheses, and the format come out like this:

SELECT (WITH DATE BETWEEN '01/11/99' AND '01/25/99') OR (WITH DATE BETWEEN '12/14/98' AND '12/28/98') OR (WITH DATE BETWEEN '11/16/98' AND '11/30/98')

Am I doing something wrong? I have data that falls into all three ranges, and can't figure out my syntax problem for the life of me.

TIA,

Matt Sorrell

[email protected]

Never mind. I figured it out. Somebody had cleared my testing table and I didn't have all of the information I thought I did. I repopulated my table and the select worked like a charm.

Thanks anyway,

Matt Sorrell

[email protected]

View this thread on the forum...