I have a textbox which a user will enter states into, CA, NV etc. I want to replace the space between states and add a common between them so I can do a where IN clause.
vb.net Code:
s = States.Text.Replace(" ", ", ") SELECT * FROM Users WHERE State IN (@States) command.Parameters.AddWithValue("@States", s)
I do it in SQL management studio and it works, in vb.net it gives no errors and no results where I should.
What's is wrong?




Reply With Quote