Scipt: I want to use a variable substitution within single quoted string

You have to put the variable within curliy brackets:

$StartDate = sql(’demo_target’, ’SELECT ExtractHigh FROM Job_Execution_Status WHERE JobName = {$JobName}’);