use chr() instead...

>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.
>Any advice or suggestion.
>
>Thanks,
>
>Gerardo