• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • Last Modified:

SQL = ". .like '" & Mike's Garage & "*'"

Variable = "Mike's Garage"
SQL = "..like '" & Variable & "*'". . the variable used contains a possesive "Mike's" which fouls up the SQL statement because of the apostrophe.  How can I parse this out so the SQL looks for the record, since the record says "Mike's Garage" not "Mikes Garage".  The SQL statement, because of the apostrophe in the name, stops at 'Mike' looking for an operator.  help help.
0
RUSTY
Asked:
RUSTY
  • 4
  • 3
1 Solution
 
RUSTYAuthor Commented:
Edited text of question
0
 
RUSTYAuthor Commented:
Edited text of question
0
 
RUSTYAuthor Commented:
Edited text of question
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
deightonCommented:
instead of the ' use ''
0
 
deightonCommented:
'Heres a function to put in the extra ' where it is needed

Private Function boggle(s As String) As String

    Dim stemp As String
    Dim c As Integer
   

   For c = 1 To Len(Text1)
   
 If Mid(Text1, c, 1) = "'" Then        'NB the "'" is <double quote><single Qt><dbl quote>
       
            stemp = stemp & "'"      'quote sequence as above
           
        End If
       
        stemp = stemp & Mid(Text1, c, 1)
       
    Next
   
    boggle = stemp

End Function

0
 
deightonCommented:
I need to be clearer because of the way it looks on screen where you have say

O'Brien you must change the ' to two adjacent single quotes i.e ' followed by ' (rather than double quotes)  my function boggle does this for you, once youve boggled your string use it in your sql.
0
 
RUSTYAuthor Commented:
Brilliant!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now