I have a SELECT statement which contains a boolean field. The result of
this query must display '0' for false or '1' for true. I will be generating
a text file with this information and a zero or a one is required. I have
tried using the CASE statement without success.
CAST(fce_subdivision as CHAR) AS fce_subdivision_aux,
CASE CAST(fce_subdivision as CHAR)
WHEN 'f' THEN '0'
WHEN 't' THEN '1'
END
I will very much appreciate your feedback.
Respectfully,
Jorge Maldonado