concatinating an SQL statement

[fergman]

Hello, I'm attempting to concatinate an sql statement that looks like this:
SQL = "SELECT * FROM [companyList] WHERE [customers] = ['"& newCompany & "']"

Basically the newCompany variable needs to contain puncuation, such as ' and possibly others. newCompany might be a person such as john's store instead of the store name. However, for the life of me I haven't been able to get it to work. what am I doing wrong?

 

[onpnt]

thread333-578277 should get you there.

_____________________________________________________________________

[sub]
Hakuna matata!![/sub]

 

[fergman]

hmmm, Is that the only option, I'm not familar with that type of function. And I don't have access to the server, it's a shared host.