Hi,
I want to include an emoji to the variable value. Is there a way to achieve that.
My data source is SQL server.
Query:
select case when '$Ineffective' = 'Ineffective' then 'Ineffective ❌' else 'Error' end
I get the output as Ineffective ?
but I want it to be Ineffective ❌
Can someone help me with it?
try one of the html codes:
@sowdenraymond I tried as below:
select case when '$Ineffective' = 'Ineffective' 'Ineffective ❌' else 'Error' end
But I got output as Ineffective ❌
Hello,
You can try with escaping:
select case when '$Ineffective' = 'Ineffective' 'Ineffective \❌' else 'Error' end
Regards
Hi @codi639
Thanks a lot for the input. I tried, it didn’t work.