I have a workflow where I am using an Execute SQL action to call a stored procedure that requires two parameters. The first parameter I can type in but the second parameter needs to come from a Workflow variable. The workflow action receives the Workflow variable but I am unable to figure out how to insert a single quote before and after the parameter. Currently the workflow errors out with the error 'Invalid Column Name'. I have found many posts where people have been able to get this to work for a SQL Request but I can not seem to find a solution for the Execute SQL action.
Here is my SQL Query.
SELECT [dbo].[GetEmailStringForGroup] (
'Purchasing',{WorkflowVariable:wrkLocationAbbr})
I have tried to use double quotes and single quotes but every time I try to do so it completely wipes out the value of the variable and supplies either '' or "" to the SQL stored procedure.
So how can I as a single quote before and after the variable so that the SQL query will execute correctly?
Thanks so much.
Randy