Re: Simply stored proc works OK but is it correct syntax ?

[Peter Brawley]

> Say the crewID was "AB01"

Poor design, atomicity failure. Store the prefix on one column, the numeric part in another.

Till you fix that ...

set @s = concat( "insert into ", 
                 @wagesyear, 
                 " (crewid) values( '", 
                 @crewid, 
                 ", ' )" 
               );