Sql adjustment for user input

[snipered]

I am trying to allow the user to pick what they want to show from a database.

I use:

strsql = "Select '" & txtitems.Text & "' from Invoice;"

txtitems.text will actually equal * (all).

This brings up just on colomn in the ms flex grid field header expr1000 then it has many rows all with * in them.

When i replace the txtitems.text with *, it shows everything just as it should.

Is there a way that i can allow for the user to select the fields without giving me undesired effects????????

[David.Poundall]

You need to drop the parenthasis. Use this

strsql = "Select " & txtitems.Text & " from Invoice;"

[snipered]

thank you very much for a quick answer and a right one.

[David.Poundall]

Personally I think SQL syntax sucks. I am always getting it round my neck as well. From many mistakes comes wisdom - or so they say. If that were true I would be a religious icon