>Hello!
>I got a problem using apostrophe in the fields, upon I need to search a data I got error because the data has apostrophe, here is a example:
>cVar="Bob's Sample"
>cSearch="SELECT * FROM CUSTOMER WHERE BusinessName= '"&cVar&"'"
>MyData.Open cSearch, objCmd, adOpenKeyset, adLockOptimistic, adCmdText
>
>At this time I got error because the apostrophe, and if I try to not use apostrophe after BusinessName I got other error because it is a character and need the apostrophe.
If using VB6, double the single quotes using this:
cSearch="SELECT * FROM CUSTOMER WHERE BusinessName= '" & replace(cVar, "'", "''") & "'"
If not using VB6, then come back here!
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com