Hi everybody,

I'm wondering if there is a way to preserve data without writing several case statements.

Here is my current code

replace cDischarge_status_code_fk ;
	with cursor_trans_stage.cDischarge_status_code_fk, ;
			cAdmit_type_code_fk ;
			with cursor_trans_stage.cAdmit_type_code_fk, ;
			cAdmit_Source_code_fk ;
			with cursor_trans_stage.cAdmit_Source_code_fk in Load_Trans

Now, if I have data in Load_Trans I don't want to replace.

If I don't have data in 3 fields in cursor_trans_stage I don't want to touch Trans. That's first IF. If values in cursor are the same as in Trans, I don't want to touch Trans.

Now, the third case can be handled by evl, correct?

Looks like I cover them all?

Actually, the data may be NULL and not empty. I don't see a simple way of preserving the info than writing lots of case statements...

Thanks.