Problem with CASE WHEN SQL-SERVER

Question

SELECT CASE WHEN VALOR > 0 THEN
VALOR ELSE
"Não tem"
END AS NOMECOLUNA
FROM BLABLABLA

I am having an error where it is not possible to convert "has not" to int.

The point is that I wanted it to return written that it does not have when the integer is 0...

Answer 1

You can convert the numeric to VARCHAR since all the results of CASE must have the same type:

SELECT CASE
         WHEN VALOR > 0 THEN CAST(VALOR AS VARCHAR)
         ELSE 'Não tem'
       END AS NOMECOLUNA
  FROM BLABLABLA

Answer 2

Within Case in SQL it is not possible to generate a column with numeric and text values as a single answer.

That is, in your code if the VALUE is greater than 0 it generates a numeric result and if less than 0 generates a text value.

I thought of 2 possible solutions:

1- Generate a separate column from the value column:

SELECT 
VALOR,
CASE WHEN VALOR > 0 THEN
"Com Valor" ELSE
"Não tem"
END AS NOMECOLUNA
FROM BLABLABLA

2-Generate output with text values for all cases (convert number to text):

SELECT CASE WHEN VALOR > 0 THEN
Put(VALOR, "numero de caracteres") ELSE
"Não tem"
END AS NOMECOLUNA
FROM BLABLABLA