Using ' & " in Findfirst

As this two characters (' and ") are reserved for string blocking in SQL statement, error occour if my searching string contains these two characters using Findfirst method.

Any ideas to solve it, when my string contains these two characters? Of course, the record should be found correctly.
HenryChanAsked:
Who is Participating?
 
dabelleiCommented:
Here's the function i'm using for the ' character it can be use for the " character either.  You just have to double your '  so if you have like o'donnell in your query your query should look like  o''donnell, that's al.

Function apostrophe(texte As String)
      temp_texte$ = texte$
      lo = Len(temp_texte$)
      x = 0
      Do While x < lo
         x = x + 1
         If Mid$(temp_texte$, x, 1) = "'" Then
             temp_texte$ = Mid$(temp_texte$, 1, x) + Mid$(temp_texte$, x)
             lo = lo + 1
             x = x + 1
         End If
      Loop
      apostrophe = temp_texte$
End Function

0
 
HenryChanAuthor Commented:
Thanks. It do work !

Henry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.