' symbol problem

[svassiliev]

I have ' symbol in some names in table Cat. strName also can have 'symbol. Example: Smith's Mountain

At that case I can't open like this:
rsCheckMet.Open "SELECT * FROM Cat WHERE NAME='"& strName &"'", adoCon

How can I go around it?

Thanks in advance!

 

[nkrst1]

Replace the ' with '' so it flows in the SQL statement.

strName = Replace(strName,"'","''&quot

rsCheckMet.Open "SELECT * FROM Cat WHERE NAME='"& strName &"'", adoCon

HTH

 

[nkrst1]

Should be noted that '' above is two instances of the single quote ('), not the double quote(&quot

 

[svassiliev]

Thanks a lot!