SQL Like Case

This will perform a SQL like SELECT with given WHEN – THEN case. Example: “WHEN Quantity Ordered > 40 THEN ‘a’ WHEN Quantity Ordered > 30 THEN ‘b’ ELSE ‘c'” The settings are: Column to store result: Name of the column the data will be stored in SQL Case (optional): When your WHEN….THEN…. statement in here. Make sure column names are spelled correctly (case sensitive) and the condition you want entered is in single quotes.

SQL Like Case

This will perform a SQL like SELECT with given WHEN – THEN case. Example: “WHEN Quantity Ordered > 40 THEN ‘a’ WHEN Quantity Ordered > 30 THEN ‘b’ ELSE ‘c'” The settings are: Column to store result: Name of the column the data will be stored in SQL Case (optional): When your WHEN….THEN…. statement in here. Make sure column names are spelled correctly (case sensitive) and the condition you want entered is in single quotes.

SQL Like Case

This will perform a SQL like SELECT with given WHEN – THEN case. Example: “WHEN Quantity Ordered > 40 THEN ‘a’ WHEN Quantity Ordered > 30 THEN ‘b’ ELSE ‘c'” The settings are: Column to store result: Name of the column the data will be stored in SQL Case (optional): When your WHEN….THEN…. statement in here. Make sure column names are spelled correctly (case sensitive) and the condition you want entered is in single quotes.