I use both singles (') and doubles (") depending upon what type of string i need. For db's I use mysql and I don't think double quotes are ever required, but some of the vbs-scripts that I generate from silk need the " so I use "".
Also, with a really long query like that, I recommend that you build up your string before passing it into DB_ExecuteSQL.
sqlSTR = "select COBJECTNAME from TD_CHECK_DEFS WHERE cScript LIKE"
sqlSTR += """";
sqlSTR += "%JOIN%"
to debug your statment.
Ideally, use the statement output by Print elsewhere to see if the db really likes the syntax.
Chris R Mead
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.