SQL Assistance, Changing "true" to 1, "false" to 0 leave oth

Ignition
1

Ok I have a column AttrValue
In that Column, I have various values

3.124
0
2.451
3.1
true
1.15
false
4.23

Here is the SQL query so far (at least part of it dealing with true false)…

SELECT TimeStamp, AttrName, (CASE WHEN (AttrValue LIKE '%true%') then 1 else 0 end) FROM QUAL_SampleData WHERE SampleUUID = '05292061-53fb-4e11-acdd-b153b7b82ed2'

But what do I need to include to leave the rest of the values as is… Most examples I find deal with entire colmns being boolean and not just some of the fields.

What I want the data to show as is:

3.124
0
2.451
3.1
1
1.15
0
4.23

It’s been about 15 years since I have done much SQL work, so think “dummies guide to SQL” with responses please. :slight_smile:

2

Try:

SELECT TimeStamp, AttrName, 
	CASE WHEN AttrValue = 'true'
	THEN 1
	WHEN AttrValue = 'false'
	THEN 0
	ELSE AttrValue
	END AS AttrValue
FROM QUAL_SampleData 
WHERE SampleUUID = '05292061-53fb-4e11-acdd-b153b7b82ed2'