If your data base is Oracle you could write your query like this (select content from c where id = 'first_name') as contenta, (select content from c where id = 'surname') as contenta ..... from dual I expect that other databases would allow you to do something similar. Then you could have a field with all your information in it "I talked to " + contenta + " " + contentb + " on the phone.".... Post edited by: svenn, at: 2007/05/15 15:50