How to write my CASE WHEN statement to result in number values? I am using for example WHEN "PUMPS' THEN '.50'' ELSE 'N/A' END. However the .5 value is in text form and I need that to be in number form.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!