Spaces in SQL query??

[tehon3299]

Hey -

I have textboxes and Im inserting the text from the textboxes into an SQL table. The only problem is it screws up when you put a space in any of the textboxes. How can I fix this??

Thanks

 

[Robby]

"select * from myTable where field = " & textbox.text.tostring & ""

 

[tehon3299]

Im actually doing that but with an INSERT statement but and I have the quotes exactly the same but if there is a space in the textbox then it just doesnt do the insert statement. Any ideas?

Thanks

 

[Robby]

It shouldnt matter if its a Select or Insert, the single quotes surrounding the string will work.
I hope that the fields data type is a string.

 

[tehon3299]

Yeah, that works perfectly. Thanks a lot!