The syntax needs to be fixed:
select CASE Telesis_Pick_Time when '' then null else 1 end as Passed from table
if you’re trying to do count, you’ll need to include a group by at the end on how it should count the data.
1 Like