in reply to Re: Dynamic SQL Bind values
in thread Dynamic SQL Bind values

Actually, it can be made to work by adding a + to the beginning: @{shift} treats "shift" as a string, and looks for a variable named @shift (which would—obligatory plug—be caught by use strict 'vars'), but @{+shift} forces it to use the keyword shift, which is what you were expecting it to do.

If God had meant us to fly, he would *never* have given us the railroads.
    --Michael Flanders