case when LEFT("%IM297%" , 1) = "<" then "Non reactive" (SQL)

Fork

select case when LEFT("%IM297%" , 1) = "<" then "Non reactive" 
  WHEN CAST("%IM297%" AS decimal) < 0.0 THEN "Non reactive"
  WHEN CAST("%IM297%" AS decimal) < 10.0 THEN "Non reactive"
  WHEN CAST("%IM297%" AS decimal) >= 10.0 THEN "Reactive"
  else "N/A"
  end

Fork

Embed on website

To embed this project on your website, copy the following code and paste it into your website's HTML: