Query's syntax is wrong - "character constant must contain exactly one character" extension

i need to write the following inside an sql query : (inside where subject = ) “Set Terminal to ““Clearing Only””” (this is the actual string)
the following warning is presented : “character constant must contain exactly one character”
thanks

Hi @Gaia_Tamir

The string value must be single quotes in execute query

Eg “Select * from table name where subject = ‘yourvalue’;”

Or if your passing a varible

“Select *from table name where subject =’”+yourvariable+"’;"

Regards

Hi @Gaia_Tamir

Can we know which activity you re using for Inputting the SQL query?

And Share the Input Query if possible?

Regards