>>I think this should handle it. I hope we do always have NULL in FK and not empty:
>>

>>if (IsNull(cursor_trans_stage.cDischarge_status_code_fk) ;
>>				and isnull(cursor_trans_stage.cAdmit_type_code_fk) ;
>>				and isnull(cursor_trans_stage.cAdmit_Source_code_fk)) or ;
>>			   (nvl(cursor_trans_stage.cDischarge_status_code_fk,"A") == ;
>>			    nvl(Load_Trans.cDischarge_status_code_fk,"A") and ;
>>			    nvl(cursor_trans_stage.cAdmit_type_code_fk,"A") == ;
>>			    nvl(Load_Trans.cAdmit_type_code_fk,"A") and ;
>>			    nvl(cursor_trans_stage.cAdmit_Source_code_fk,"A") == ;
>>			    nvl(Load_Trans.cAdmit_Source_code_fk,"A"))
>>				** Do nothing - all empty or exactly the same
>>			else
>>				replace cDischarge_status_code_fk ;
>>				with nvl(Load_Trans.cDischarge_status_code_fk, ;
>>				cursor_trans_stage.cDischarge_status_code_fk), ;
>>				cAdmit_type_code_fk ;
>>				with nvl(Load_Trans.cAdmit_type_code_fk, ;
>>				cursor_trans_stage.cAdmit_type_code_fk), ;
>>				cAdmit_Source_code_fk ;
>>				with nvl(Load_Trans.cAdmit_Source_code_fk, ;
>>				cursor_trans_stage.cAdmit_Source_code_fk) in Load_Trans	
>>		    endif	

>>
>No, this would not work, if we have something in cursor and something in Trans, for example, cursor.Field1 = "B" and Trans.field1 = "C". I want to preserve C and don't touch the record if cursor other fields are empty.

What if I try:

field1 Null = 0
otherwise 1

field2 Null = 0
otherwise 10

field 3 Null 0
otherwise 100

========================
Or something along the lines?...