你的问题,我遇到过,这是我的解决办法:'********************************************************************************** '功能:去掉字符串内部的单引号字符 '********************************************************************************** Public Function DeleteDyhInStr(ByVal ChStr As String) As String Dim i As Integer, s As String s = ChStr i = InStr(s, "'") Do While Not i = 0 If i = 1 Then s = Mid(s, 2) ElseIf i = Len(s) Then s = Left(s, Len(s) - 1) Else s = Mid(s, 1, i - 1) & Mid(s, i + 1) End If i = InStr(s, "'") Loop DeleteDyhInStr = s End Function '********************************************************************************** '结束 '**********************************************************************************
'功能:去掉字符串内部的单引号字符
'**********************************************************************************
Public Function DeleteDyhInStr(ByVal ChStr As String) As String
Dim i As Integer, s As String
s = ChStr
i = InStr(s, "'")
Do While Not i = 0
If i = 1 Then
s = Mid(s, 2)
ElseIf i = Len(s) Then
s = Left(s, Len(s) - 1)
Else
s = Mid(s, 1, i - 1) & Mid(s, i + 1)
End If
i = InStr(s, "'")
Loop
DeleteDyhInStr = s
End Function
'**********************************************************************************
'结束
'**********************************************************************************