On further thought,  The where clause could possibly even be simplified to the following.


WHERE 1 = CASE
               WHEN FormrfpNumber <> '' AND o.rfpNumber = FormrfpNumber THEN 1
               WHEN FormTitle <> '' AND o.title = FormTitle THEN 1
               WHEN FormAwardType <> -1 AND o.awardtypeid = FormAwardType THEN 1
               ELSE 0
           END
______________________________________________________
  <file:///E:/EUColor.gif>

Bill Grover

Supervisor MIS   

Phone:

301.424.3300 x3324

EU Services, Inc.   

FAX:

301.424.3696

649 North Horners Lane   

E-Mail:

[EMAIL PROTECTED]

Rockville, MD 20850-1299   

WWW:

<http://www.euservices.com/> http://www.euservices.com

______________________________________________________


[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to