Missing expression in my SQL statement? 1

[mrdod]

I'm attempting to pull information off a Lotus Notes db and have no idea what the format of the information looks like as it differs from line to line. When I run the SQL statement I get a Syntax Erro (missing operator) in query expression. This variable has "/" and "'" and ":" and "&' in it. I thought by putting it in the format I did this would work, obviously I'm wrong. I'd post the rest of the SQL statement but the thing is pretty big and this seems to be the only one I'm having problems with.

,""" & strproblemdesc & ""","

Any ideas?

 

[Remou]

The ' will cause problems. Have you tried:

,'" & Replace(strproblemdesc,"'","''") & "'

 

[mrdod]

Thanks Remou I never had to use "Replace" I just always used the """ & text & """ and it seemed to work.