select
c.nome,
c.cpf,
case when c.inscr_est = '' then c.rg else c.inscr_est end as IE,
c.logradouro,
c.cep,
c.fone,
c.nome_reduzido,
c.celular,
c.numero,
c.bairro,
c.complemento,
c.municipio,
c.uf,
c.email,
c.contato
from cliente c
order by 1