Here is what I have in the results, not the query. Substr( Na_First_Last, 1, Instr( Na_First_Last, ' ', 1,1)) This works fine, however.......I need to add this piece, RPAD(COLUMN, 48, ' '). My struggle is I need to built this in the query and not the results. Any help would be appreciated