I have a situation where I need to do two separate lookups which will return new values from a table if the key is found. If both lookups fail, I already have what I need and no further processing is necessary. If one or both of the lookups were successful then I need to do some additional processing with what was found in the lookup table.
My question is what value is in the lookup table non-key value(s) if the lookup fails? It does not appear to be null since I based subsequent logic on null values.
Thanks in advance.
Returned Value on Lookup Stage
Moderators: chulett, rschirm, roy