How do I include the apostrophe?

[rkinrade]

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?

 

[swampBoogie]

Double it

insert into stores(name) values('John''s store')

 

[rkinrade]

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.

 

[JamesLean]

Replace(txtCustInfo(1).Text, "'", "''")

You should really post these questions in the VB forum in future.

--James

 

[rkinrade]

Thanks James