Case When Statement resulting in number values

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.

nquinonez5 pointsBadges:

Time stamps on Websites

Is there anyway to modify time stamps on a website? For example transaction times on NFL.com.

Mrgrizzlybear5 pointsBadges:

ASFU licensing

When implementing PREMIA solution, is ASFU the best way to go as opposed to EE Perpetual licensing? This considering that QV is gonna be an integrated system, along side other application systems. Which one is more economical with enhanced functionality

KIM20185 pointsBadges:

Reset memory on Cheque Writer machine

My baby press something and now it needed a password on my cheque machine. Is it possible that we can reset the memory or reset the password?

CrystalLake5 pointsBadges:

Convert of SHOW file to PowerPoint

How can I convert a SHOW file to plain PowerPoint? Thanks!

abetning5 pointsBadges:

Compare file in RPG AS/400

How to check if the file a contents are inside file b? File contains table q,w,e,r,t,y.file b contains q and w. I want to check whether q and w contents are same in file a and file b. If not, I want to display an error message.("FILE B IS NOT UPDATED")

sampathrsk20 pointsBadges:

How can I get the email body, receipt and sender from EWS?

Would anyone know how to get an email body, receipt, sender, CC information using Exchange Web Service API? I only know how to get the subject. Here's what I have: ExchangeService service = new ExchangeService(ExchangeVersion.Exchange2010); service.Credentials = new NetworkCredential("user",...

ITKE1,075,065 pointsBadges:

Getting Errors with Solidity Contract

We are creating a dApp to be run on Ethereum. The page loads properly and the subform loads as expected. However, once the information is entered and the "submit" button is clicked, nothing happens. In our current test environment (Metamask), we expect to receive a confirmation screen for the...

AXbean5 pointsBadges:

Microsoft PowerPoint: Change file name of template

I'm in the process of creating PowerPoint templates for my organization. Whenever I open one of these files, it's default file name is "Presentation1, Presentation2, Presentation3, etc. I need to change these - can I do that?

ITKE1,075,065 pointsBadges:

Corrupted log file on Exchange still needs to be restored.

How would you recover Exchange server when the log file is corrupted?

Karl Gechlik9,860 pointsBadges:

Opening NSF file without Lotus Notes

My lotus notes is not opening. Is there any way I can view the NSF archive files in some other program? The problem is that Lotus notes is corrupted and just not opening.

Deepaksapra5 pointsBadges:

How to uninstall OracleserviceXE

I am trying to install a new version of Oracle 10g. I thought that I had uninstalled the previous version but whatever I do I get the message "OracleServiceXE is present on the system". How can I fix this please? Des

Desjacks5 pointsBadges:

LCD command not working in FTP

Hi, When trying to FTP AS/400 source members to local desktop LCD subcommand of FTP is not working. when using the command LCD C:\ ERROR IS COMING CHARACTER ':' IS NOT ALLOWED in object name so because of this unable to copy as/400 source code to local desktop.

6r2,135 pointsBadges:

Shockwave Flash keeps crashing in Google Chrome on Ubuntu

So I'm running both Ubuntu on my PC. In Google Chrome, Shockwave Flash keeps crashing every single time. It's getting quite bothersome. A friend of mine tried it on his Windows 10 system and it crashed too. Why is this happening? How can I fix it?

ITKE1,075,065 pointsBadges:

Need help in identifying .CFG format

I have a need to track changes to an equipment .CFG file that store equipment calibrations, but when I open the file in notepad or others, the display is alien gibberish. How can I identify the format and convert it to a text file? Here is an example of the file as it appears in Notepad. 2   ...

mrlaundry5 pointsBadges:

Cannot install CheckPoint VPN on Windows 10

I'm trying to install a CheckPoint VPN but I keep getting this error message: Error 26630 - Failed to copy driver. I'm not sure what to do here. I'm currently on Windows 10. Can someone help?

ITKE1,075,065 pointsBadges:

How to sync iCloud mail in Windows 10

I'm currently trying to sync my iCloud email through the Windows 10 Mail app but it's not working. I was able to sync my Calendar and Contacts but the Mail will not go through. I've turned on the switch and click save. But then it goes right back to being off. Any suggestions?

ITKE1,075,065 pointsBadges:

Starting a career as SQL database developer

I recently have finished my btech 3rd yr via cse. I am quite interested in SQL so I want to be a SQL database developer. So please guide me in what other languages I should learn and what other skills I should learn too.

Rajiv62535 pointsBadges:

Tablet can’t connect to Wi-Fi

On my tablet, I can't connect to Wi-Fi. It has a authentication problem - what do I do?

thatsthat95 pointsBadges:

What is SAP?

What does SAP stand for?

pmcelroy635 pointsBadges: