I'm using the following case:
CASE WHEN RESPOSTA.CD_RESPOSTA = 1 THEN 'ATENDE'
WHEN RESPOSTA.CD_RESPOSTA = 2 THEN 'NÃO ATENDE'
ELSE 'NÃO APLICÁVEL' END AS DS_RESPOSTA
I have the value of ANSWER.CD_RESPOSTA: 2. The field is an Int, not null.
But it's always coming back to me 'NOT APPLICABLE'. What am I doing wrong?