DSXchange

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.

I depends what the return value data type is. could be null or in some cases it is zero

The data type is integer.

Looks like it is returning zeroes. Thanks for the help.