Thanks Sean ... yes its formatting and i do undertsand tsql is not the best approach for doing same but for technical reason i want to do it on the back end / the asp.net gridview that is being used also to populate results has not been helpfull as well