• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• This is a simple function to avoid apostrophes error for processing by SQL Server or Oracle server

This is a simple function to avoid apostrophes error for processing by SQL Server or Oracle server

This is a simple function to avoid apostrophes error for processing by SQL Server or Oracle server

Rate This is a simple function to avoid apostrophes error for processing by SQL Server or Oracle server

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

msgbox SingleCode("biju joy's Bok")
end sub

Public Function SingleCode(ByVal UrString As String) As String
  If InStr(UrString, "'") > 0 Then
    SingleCode = Replace(UrString, "'", "''")
    Else
    SingleCode = UrString
  End If
End Function