S
sassie_blueeyes
I have four fields in a table that contain an identifying number. I want to
write a query with an expression that looks for the first field that contains
a value and return that value. If the first field is null, I want the next
field to be looked at, if it has a value, I want that value returned, if it
is null, I want the next field to be looked at and so on.
ma_case_num varchar2(9byte)
ap_case_num varchar2(9byte)
fs_case_num varchar2(9byte)
ss_case_num varchar2(9byte)
write a query with an expression that looks for the first field that contains
a value and return that value. If the first field is null, I want the next
field to be looked at, if it has a value, I want that value returned, if it
is null, I want the next field to be looked at and so on.
ma_case_num varchar2(9byte)
ap_case_num varchar2(9byte)
fs_case_num varchar2(9byte)
ss_case_num varchar2(9byte)