Select into difficulties

Hi.

I am trying to populate a variable via a simple SELECT INTO statement. But, if the SELECT INTO returns no rows, I want to populate the variable with something else and continue the procedure. I DO NOT want to exception-out of the proc. Here is the statement w/in my proc:

SELECT	MATCH_PROD_ID
INTO		NEW_PROD_ID_OUT
FROM		PRODUCT_UP-CROSS_SELL
WHERE	PRODUCT_UP-CROSS_SELL.BASE_PROD_ID = PROD_ID_IN
AND	PRODUCT_UP_CROSS_SELL.MATCH_TYPE = 'U'

PROD_ID_IN is an incoming parameter.
If the above returns no rows, I just want to populate NEW_PROD_ID_OUT with PROD_ID_IN. Very simple, I think, but I'm unable to determine a way of doing it.

thanks in advance.

Laura Bellini
laura_bellini_at_compaq.com Received on Wed Jan 14 1998 - 00:00:00 CST