• If you modify the code for the Select variable as follows.

    SELECT @variable = '''TEST'''

    Then 1,2,3 works and not 4 and 5