SQL where question

Hi, I am using database connector for my sql. I am using  execute query microflow and for the sql , i need to give where clause value in single quotes. However,  it keeps giving me error(image below). Do I need to protect the single quotation? select *  from call_master_table cm where cm.reporting_server_id='0001723176' Thanks. Manyam
1 answers

The whole query goes in quotes, and then you should escape the internal single quotes with an extra single quote. So like this:

'select * 
from call_master_table cm
where cm.reporting_server_id=''0001723176''