Fórum inserir caracter de % #605732

select  convert(varchar,sum ((((1000)/10)*100)/100)) + '%'  as PERCENTUAL_DE_DESCONTO

select distinct
            A.cdfil FILIAL,
              case a.cdfil                 when 17 then 'CIDADE NOVA'
                                           when 18 then 'DOCA'
                                           when 26 then 'PATIO BELEM'
                                           when 45 then 'BR'
                                           when 60 then '14 DE ABRIL'
                                           when 65 then 'DUQUE'
                                           when 70 then 'BOULEVARD'
                                           when 75 then 'CALL CENTER'
                                           when 85 then 'PARQUE SHOPPING'
    
                      end PAGAMENTO,
              sum (case a.tppag when 1 then (a.vrliq) END) as NORMAL,
               sum (case a.tppag when 2 then (a.vrliq) END) as CONVENIO,
                sum (a.vrdsc) as DESCONTOS_RECEITAS,
                 sum ((((a.vrdsc)/a.vrliq)*100)/100)  as PERCENTUAL_DE_DESCONTO,
                  sum (a.vrliq) as TOTAL

                 from fc31200 a where
                         a.cdfil<>150 and
                          a.dtope  between :dtinicial and :dtfinal and
                           a.tppag <> 3 and
                            a.tppag <> 6 and
                             a.cdtml <> '80' and
                             a.cdfil=75
                              group by a.cdfil