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

showing a certain headline in the header of a gridcolumn and giving a field a certain name are two very different things!
You should avoid putting UI affairs into the datasources of UI elements.