#2690 Why to use boolean if we have strings ? SQL -1 
CASE WHEN lc.injected = true THEN 'Yes' WHEN lc.injected = false THEN 'No' ELSE 'N/A' END AS is_injected,
CASE WHEN lc.recycled = true THEN 'Yes' WHEN lc.recycled = false THEN 'No' ELSE 'N/A' END AS is_recycled,
CASE WHEN lc.issued = true THEN 'Yes' WHEN lc.issued = false THEN 'No' ELSE 'N/A' END AS is_issued,

The target table contains boolean types, and some others are pseudo-booleans using strings :-\

By Anonymous, 2024-12-12 11:53:12