Need help with this M query please

Hi lbendlin 

thanks for that.

I tried with single quotes too. but it didn't work either.

intead of SP, I'm trying to run the SQL query directly, but I still get below error on the parameters.

= Sql.Database("MyServer", "My_DB", [Query="SELECT
COUNT(distinct c.co_num) AS [Total Order Count],
CAST(SUM(it.uf_emdaSQMperUnit * co.qty_ordered)AS DECIMAL (18,2))AS M2,
CAST(SUM(it.uf_emdaKgMtr * uf_emdaLength * co.qty_ordered) AS DECIMAL (18,2)) AS [Weight]
FROM co_mst c WITH (NOLOCK)
JOIN coitem_mst co WITH (NOLOCK)
ON c.co_num = co.co_num
JOIN item_mst it WITH (NOLOCK)
ON co.item = it.item
WHERE
CAST(c.order_date AS DATE) = '"DateFrom"'
AND c.whse BETWEEN '"WhseFrom"' AND '"WhseTo"'
AND ISNULL(c.uf_emdaFactory,'') BETWEEN ISNULL('"FactoryFrom"','') AND ISNULL('"FactoryTo"','')
AND c.stat = 'O'
AND co.qty_ordered > 0"])

below is the error I get for above query

when I add && on the parameters, it returns below error

any help would be greatly appreciated