[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
conditional statement
- Subject: conditional statement
- From: "Cadenas, Maria (MT)" <MCadenas@DOW.COM>
- Date: Wed, 7 Feb 2001 10:30:21 -0500
I'm having trouble with the following conditional sentence. I need a
statement that would select only employees with an employee record = 1 and a
status NOT equal to A,Q,P, or U. It is the OR clause that is giving me
trouble. Any suggestions?
if #Empl_Record = 1 AND ($Status <> 'A'
OR $Status <> 'Q'
OR $Status <> 'P'
OR $Status <> 'U')
do Select-Address
else
do Fetch-Address
end-if