When wanting to insert info from a textbox such as "John's Store", how would I include the apostrophe in John's without the SQL statement crashing?
Thanks, actually the code is being run from VB and looks something like this: insert into stores(name) values ('" & txtCustInfo(1).Text & "'). The value of txtCustInfo(1).Text being "John's Store". I guess what I need is VB code to replace the apostrophe before sql gets it.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.