Brief query puzzle

I'd like to write a query that returns a status code value as it is stored in the database UNLESS the current system date falls outside of two date attributes that are in the same table, in which case return an "X" for the status code value.

The table looks like this:

CUSTOMER table

customer_number		decimal
status_code		char(1)
effective_date		date
expiration_date		date

The data looks like this:

customer_number	status_code	effective_date	expiration_date
--------------- -----------	--------------	---------------
1		A		1-jan-93	31-dec-93
2		A		1-jan-93	2-jan-93
3		R		1-dec-93	31-dec-93

The current system date value is 19-dec-93.

The results of the query should be:

CUSTOMER_NUMBER	DERIVED_STATUS_CODE
---------------	-------------------
1		A
2		X
3		R

Thanks in advance for your creativity. I will post all valid solutions.

--
-------------------------------------------------------------------------
Kim Medlin                             Email:    klm_at_atlanta.dg.com
Atlanta Systems Integration Services   CEO:      Kim Medlin:DGC
Data General Corporation               Phone:    404 705-2653


-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

It's nice to be important, but more important to be nice.


-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-