Hi<BR>does anyone know how to put, for example,<BR>SELECT * FROM X WHERE Y="BOB*",<BR>into a string for an ADODB call. The problem is that the double quote means the end of a string in VBScript. <BR>Thanks
I have used the following:<BR>SQLqry="Select * from X where y='bob*'"<BR><BR>but this might work also:<BR>SQLqry="Select * from X where y=""bob*"";"
I have always used the following to make sure things stay straight:<BR><BR>strDQ = chr(34)<BR>sql = "SELECT * FROM X WHERE Y=" & strDQ & "BOB*" & strDQ<BR>