[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



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