May be you can suggest something better for this kind of client transformation - what would you suggest?

 select resource1, booking_id, start_time, end_time, flex_tspan,;
         layer, backcolor, forecolor, clip_sp, clip_loc,;
         padr(space(iif(locked,2,0))+iif(empty(department+category+item),replicate('**'+alltrim(lsndescrip)+'** ',40),;
         alltrim(modifiers)+' '+proper(alltrim(gst_name))+' '+;
         alltrim(lsndescrip)+' '+alltrim(str(booking_id,16))),200) as display_msg, locked, ;
         iif(nvl(notelength,0)>0, .t., .f.) as isnotes ;
         from csrTemp;
         into cursor csrRetCursor

As you see, we have two "computed" columns here - do you know of a simple way to create them on the fly somehow once I get the results using stored procedure?