• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• An simple function to handle SQL strings that include a single apostrophe.

An simple function to handle SQL strings that include a single apostrophe.

An simple function to handle SQL strings that include a single apostrophe.

Rate An simple function to handle SQL strings that include a single apostrophe.

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

Dim strFind As String
Dim strReplace As String

  On Error GoTo HandleError:

  strFind = "'"
  strReplace = "''"
  SQLTextPrep = Trim(Replace(strStringIn, strFind, strReplace))
  
  Exit Function

HandleError:
   MsgBox "FUNCTION ERROR: SQLTextPrep " & Err.Number & " " & Err.Description
End Function