Replace ` with ' in all data in a specific field

[Khalil Handal]

Hi,


I have a database and I notice in some of the data I have the (`) instead of (') .
Example: a record shows: farmer`s house while ti should be farmer's house.
I used the following code to identify these records:

SELECT tblBooks.BookTitle
FROM tblBooks
WHERE (((tblBooks.BookTitle) Like "*`*"));

I am trying to use an update query to replace the (`) with (') in these 159 records. Note that the filed data might have more than one (`) in ti.
I tried the following code that gave an error.

UPDATE tblBooks
SET BookTitle=REPLACE(BookTitle, '`',''')
WHERE BookTitle like "*`*";

I am having an error.
Any suggestions?

Khalil

[Welshgasman]

You can use " ?

tt = "this is ~ a test"
tt=replace(tt,"~","#")
? tt
this is # a test

In fact that is what I normally use?

[CJ_London]

try

WHERE instr(BookTitle,"`")>0

[Khalil Handal]

Hi,
Thank you.
Mission accomplished.

[CJ_London]

for the benefit of others who have the same sort of problem - please can you post your solution