List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 14 2000 4:05pm
Subject:Re: GENERAL SQL
View as plain text  
At 9:32 AM -0500 09-14-2000, Chris McKeever wrote:
>I have a sql statement:
>
>strSQL = "select * from tablename where fieldname = '" & valuetofind & "' "
>
>HOWEVER, it turns out one of the valuetofind is  GARY'S anyone know how to
>get around this problem?  Double quotes dont work
>and I am trying to keep this as a generic SQL statement and cant escape the
>'

You can't escape the single quote?

Why not?  That's the answer to your problem.

-- 
Paul DuBois, paul@stripped
Thread
GENERAL SQLChris McKeever14 Sep
  • Re: GENERAL SQLSteve Ruby14 Sep
  • Re: GENERAL SQLPaul DuBois14 Sep