Hi Fred Thank you for your reply, I think this is a fine solution.
"incompatible data types in combination" for case when statement