• Actually, this version should be faster:

    select * from @SAMPLE_DATA sd

    where @strname like sd.SD_TEXT + '%'