SQL / BROWSER UTILITY
SQL CASE Builder
Turn two-column mappings into a SQL CASE expression.
Processed locally in your browser. Your data is not uploaded.
Good to know
Paste two columns from a spreadsheet, or comma-separated key/value pairs, without a header. Choose the matching separator. Quoted fields can contain the separator, quotes or line breaks. Blank rows are ignored and each mapping must have exactly two fields. Results are always text. The column/expression is included as written; this tool never validates or executes SQL. Unmatched keys return NULL because no ELSE is added.
Example: A and Apple separated by a tab produce WHEN 'A' THEN 'Apple'. Numeric key mode produces WHEN 1 THEN 'Apple'.