In the exercise TIO-0903-TextBoxWithLIKE you state in bullet 2 “.., select WHERE and set the column to au_lname. But for the operator, select LIKE. The source will control named TextBox1.”

SelectCommand="SELECT [au_id], [au_lname], [au_fname], [city], [state] FROM [authors]
WHERE ([au_lname] LIKE '%' + @au_lname + '%')">
            <SelectParameters>
                <asp:ControlParameter
                    ControlID="TextBox1"
                    DefaultValue="CA"
                    Name="au_lname"
                    PropertyName="Text"
                    Type="String" />
            </SelectParameters>

But in “your code should be similar to the following”

WHERE ([State] LIKE ‘%’ + @state + ‘%’)”>
            <SelectParameters>
                <asp:ControlParameter
                    ControlID="TextBox1"
                    DefaultValue="CA"
                    Name="State"
                    PropertyName="Text"
                    Type="String" />
            </SelectParameters>

So should one have used set the column to state?

That was my assumption, yes. When I gave this to my students, I told them that the first description under instruction #2 (bottom of page 223) was in error, and that the second sentence should read "When you go through the Configure Data Source Wizard, select WHERE, and set the column to state". (Instead of setting the column to au_lname.)