ExecuteQuery: How to pass a default variable in SQL Query

[shaan009 (shahin)]

I am trying to pass a default variable in SQL Query in “Where clause” in ExecuteQuery Activity. But err is coming as String Constants Must end with double quote.
here is my query:

"SELECT
Columsnames
FROM
mydatatableName
INNER JOIN otherDatatablename
ON (mydatatableName.Number = otherDatatablename.Number)
WHERE
mydatatableName.Number =’ “+policyNumberFromClaim.ToString+” ’ "

here policyNumberFromClaim is default variable created in WF

[supermanPunch (Arpan)]

@shaan009 Most probably you need to make the String in a Single Statement and not use multiple lines

[bcorrea (Bruno Correa)]

you need an extra quote in the end there…