Show different value from different table based on existing value

[robbeh]

The expression should convert the text "002" to number value 2 and concatenate with string "Code" to result in "Code2".

Ah, I get it now - thanks June. The issue is that was just an example I pulled out of thin air since the data is sensitive.

A better example is:

Codes: RMR, OLP, DDF, LG
Need to say: Read My Reader, Over Long Politics, Deep Down Funny, Lifes Good

That kind of thing.

Sorry I should have used a better example.