Using Wildcards when the charachter is a Quotation mark ["]

[Arnold]

Hello all.
I know that it is possible to query with a wildcard for special characters such as # ] , [ using the []. However I cant seem to find the solution to query my column for [ " ].

I actually need to update the column [url] to remove all the characters or values in that string after the Quotation mark ["].

Example in this url
http://www.costco.com/Raven-Extra-Strength-Nitrile-Gloves-Size-Large-1000ct-(10100Ct-Boxes).product.100027501.html">http://www.costco.com/Raven-Extra-St...t.100027501.ht
I would like to keep only http://www.costco.com/Raven-Extra-St...100027501.html



Thanks in advance

[June7]

Will there always be > character following the quote?

Left(x, InStr(x, ">")-2)

[ItsMe]

Since functions within a query are VBA, you should be able to double up on the double quotation. I have searched for quotations using instr() behind forms