{CALL:X} SQL Query

Can I use CALL:X to get the result of an SQL query?
I have tried using {CALL:@@CostPrice}

I also tried creating a function to handle this for me
Handler: PriceList
function costprice() { var costprice = sql.Query(@@CostPrice).First; return costprice }
and calling the result using {CALL:PriceList.costprice}

@@CostPrice returns the correct result

You can put the SQL into the script and call the script. Or you can use REPORT SQL DETAILS tag.

i was missing the fields & line format {REPORT SQL DETAILS:@@CostPrice:F.Price::{0}}