Sam Runyon
asked on
Replace text
I need to replace some alarms with just the word Alarm or OK I need a wildcard in front of Alm because the only thing that is constant is the last 3 letters in the alarm.
Here is what I am trying.
CASE WHEN CHTKSTS.value = '%Alm' THEN 'Alarm' ELSE 'OK' END as [Chemical Tank Communication Status]
ay help?
Here is what I am trying.
CASE WHEN CHTKSTS.value = '%Alm' THEN 'Alarm' ELSE 'OK' END as [Chemical Tank Communication Status]
ay help?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER