Hi There,

I have an SQL command which i have build up, and the SQLfieldname are simply strings which I have built up by

chr(39) & strWhatever & chr(39)

the problem is when strWhatever contains the ' or chr(39) and that causes an error on my SQL, how do i exclude the ' in the variable besides just replacing it with another character?

cheers


str = "INSERT INTO WhateverTable (" & SQLfieldname & ")"
str &= " VALUES (" & SQLfieldvalue & ")"