Using Conditional Statement in an SQL Query?

Ignition
4

The link shows an example:

SELECT OrderID, Quantity,
CASE
    WHEN Quantity > 30 THEN 'The quantity is greater than 30'
    WHEN Quantity = 30 THEN 'The quantity is 30'
    ELSE 'The quantity is under 30'
END AS QuantityText
FROM OrderDetails;

Replace the table and column names with your table/column names. You may need to remove some columns from the SELECT statement as you may not have as many columns. (For example Quantity would be replaced by AshleyVfd_Hz)

Also, show some examples of SQL statements that you have tried that have not worked. Make sure to post them as preformatted text.