>This is client's request that grid should say % as the field name. It picks what ever field name we gave in the sql

Can you define the field name as something wierd, then iterate through the grid columns and set the header for that column? Something like the following pseudo-code

SELECT ........, % field AS _p_c_t, ............. FROM etc. INTO CURSOR myCursor
FOR EACH column IN myGrid
     IF column.controlsource = "_p_c_t"
          column.header.caption = "%"
    ENDIF
ENDFOR