retriving 3 columns data frm sql in 1 textbox

Question

Hello,
[1] I have created one data report(student report).
[2] which shows records of students as per the fields selected from various combos situated at form2 for that I wrote a record set (bunch of sql statements) fired on command_click and it works well.....
[3] Now I am having fields like: FIRST_NAME,MIDDLE_NAME,LAST_NAME in database table
[4] For that I have to take one TextBox as FULLNAME which is not included in table but I have to concatenate these 3 fields to view FULLNAME......
[5] I don't know how to do so.......