Using Single Quotes in DataBase

[Guest]

I have a database which has a field "myfield" that has a value "Owner's Text
Book". I am trying to construct an sql query to find the record where
myfield equals "Owner's Text Book". How do I get the Sql query to accept
the single quote as part of the string I'm looking for,i.e.,

Select * FROM myTable WHERE myfield = 'Owner's Text Book'. The OLEDB query
command interprets the ' in Owner's as a delimiter.

 

[Cor Ligthert [MVP]]

Dennis,

I am not sure of this however did you already try to use parameters?

It is easy to use.
See this sample on our site for SQL server (there is as well a little bit
more complex sample for OleDb)
http://www.windowsformsdatagridhelp.com/default.aspx?ID=886bba68-8a2f-4b99-8f66-7139b8970071

I hope this helps,

Cor

 

[Terry Olsen]

You just have to make it a double-single-quote:

Select * FROM myTable WHERE myfield = 'Owner''s Text Book'

 

[Guest]

Thanks...that works!
--
Dennis in Houston

You just have to make it a double-single-quote:

Select * FROM myTable WHERE myfield = 'Owner''s Text Book'