SQL where question

0
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
asked
1 answers
3

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''
'

 

answered