How can I search for " in a string using the InStr function

[Johnnie100]

Hello and help,

I have some records that are separated by a ", when I try and search for this character in ASP it seems to bring back different results than when I use it in VB.

The code I am using to find the location of the quotation mark is:

ll = InStr(sl + 6, MainStr, """&quot

Can anyone help or suggest a better way of finding this character within the string please.

Thanks
Johnnie

 

[baddos]

Try this:

ll = InStr(sl + 6, MainStr, chr(34))