SQL Select string where search criteria contains a ' character? [RESOLVED FISH]

[Wokawidget]

I have a surname in my DB, which is:

O'Keafe

But if I build a search SQL string like:

SELECT * FROM tblUsers Where Surname = 'O'Keafe'

then this gives an error

Any ideas?

Woka

[Wokawidget]

Got it

Answer is:

select * from tblUsers where Surname = 'O''Keefe'

[mendhak]

How could you not know something as simple as this? And you got a new job??!?

Somebody save us!

[Wokawidget]

I know...I am a bad badger

*sob*

Anyways, I do know.....now

Woka

[bjay_tiamsic26]

i have the same case ..

but im about to search in a database

i created a table named tblBook, with fields BookId BookName and Copyright,i have a record on BookName which is One's Self

"Select BookId From tblBook where BookName like '" & txtBookName.Text & "' "
i have this code in visual basic 6.0..

errors occur about the apostrophe sign (')

[si_the_geek]

Welcome to VBForums

Please do not reply to old threads just because they have a similar issue. For a variety of reasons it is better to create a new thread instead, and if apt link to the old one.

For information on how to solve the issue, see the article How do I put the ' character into an SQL string? from our Database Development FAQs/Tutorials (at the top of the Database Development forum)