SQL*Loader mutliple when clauses for the same column

Hello All,  

Looking for help using mutiple when clauses for the same column with SQL*Loader.  

For example, I want to load records that have a status of A, B or C.  

Within sql*loader, WHEN (STATUS = 'A') OR (STATUS = 'B') OR (STATUS = 'C') INVALID.
and WHEN (STATUS = 'A') AND (STATUS = 'B') AND (STATUS = 'C') is technically correct, but it will never load since the status cannot be 3 things at once.  

Note that it is the SAME column being used each time. WHEN dept=10 AND emp=22 works fine (since they are differnt columns).  

I also tried an IN clause and that failed. A call to Oracle support had no alternatives.  

I can't believe there is not a work around.  

Any ideas?    

John Fedock
iXL, Inc.
Glen Allen, VA 23060  

 <mailto:jfedock_at_ixl.com> jfedock_at_ixl.com http://www.ixl.com <http://www.ixl.com/>  

This message is intended only for the use of the addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, dissemination of this communication is prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Received on Fri Jun 02 2000 - 10:19:56 CDT