I'm having a hard time with a replace. I want to replace text where it begins with " and replace that with nothing. From there I'm going to build on this with more replace functions. So I don't think a where clause will work
replace(f2, like '"%', ''),
"RUBBER * ROLLER TIRE 6"" DIA."
"BOLT * HEX 3/8""-16 X 2 1/2"""
What I'm trying to achieve is RUBBER ROLLER TIRE 6in DIA, BOLT HEX 3/8in-16 X 2 1/2in