changing result of select query in tablefield

Hi

I have a tablefield which gets its values from a select query, eg

tblField = select val1, val2, val3
              FROM tbl1

My problem is that in the table tbl1, val2 has 3 different values in
it which are abbreviations. On my tablefield however, i need to
display the whole thing. EG in tbl1, val2 can be SOS, PTO or ET. If
the select query returns PTO for val2 then i would need to display
Please Turn Over.

Hope this makes sense and any help would be appreciated!