[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Switching in the Where Clause
- Subject: Switching in the Where Clause
- From: NEDOLPH@AOL.COM
- Date: Mon, 11 Sep 2000 16:56:54 EDT
Assume I have a MyTable of 1500 rows; some of RowType = "A" and some of RowType
= "B"...
For the "A" rows I want to:
Select Blah...
>From MyTable
Where field1 > 6
and field2 > 'm'
and field3 <> 'sold' !CONTAINS A QUOTED REFERENCE
for the "B" rows, I want to suppress the last line of the WHERE clause to make:
Select Blah...
>From MyTable
Where field1 > 6
and field2 > 'm'
I tried switching the last clause in and out with an IF statement (IF Rowtype =
'A' ...) but that failed miserably. What am I doing wrong?
Sincerely,
Norman Dolph