I have a simple lookup that looks up a name based on a code -- very typical.
However, if the table I'm looking at has zero rows, then the lookup returns
the value of the CODE instead of returning nothing. Why is that? Can this
be avoided somehow?