Fórum problema com o case #54838

select
  coalesce(nome_razao,nome_fantasia) ||
  (case
     when not (nome_razao is null) and
          not (nome_fantasia is null)
     then ´ --> ´
     else ´´
   end) ||
  (case
     when nome_razao is null
     then ´´
     else coalesce(nome_fantasia,´´)
   end) as Campo1Result,
  cod_cliente as Codigo
from
  clientes

select 
  (case
    when (not (nome_razao is null) and (nome_razao <> ´´)) and (not (nome_fantasia is null) and (nome_fantasia <> ´´)) then
      nome_razao || ´ --> ´ || nome_fantasia
    when ((nome_razao is null) or (nome_razao = ´´)) and (not (nome_fantasia is null) and (nome_fantasia <> ´´)) then
      nome_fantasia
    when (not (nome_razao is null) and (nome_razao <> ´´)) and ((nome_fantasia is null) or (nome_fantasia = ´´)) then
      nome_razao
  end) as Campo1Result, cod_cliente as PK

from
  clientes

select 
  (case 
    when (coalesce(nome_razao,´´) <> ´´) and (coalesce(nome_fantasia,´´) <> ´´) then 
      nome_razao || ´ --> ´ || nome_fantasia
    when (coalesce(nome_razao,´´) = ´´) and (coalesce(nome_fantasia,´´) <> ´´) then
      nome_fantasia 
    when (coalesce(nome_razao,´´) <> ´´) and (coalesce(nome_fantasia,´´) = ´´) then 
      nome_razao 
  end) as Campo1Result, cod_cliente as PK 
from 
  clientes