Isolating Quote Marks

[dgriffis1231]

I am trying to isolate a field with quote marks (").

WHERE (((dbo_AC_ECONOMIC.SECTION)="));

but that does not work.. any ideas please?

 

[CJ_London]

Are you saying a field with a single double quotation mark?

if so, try

WHERE (((dbo_AC_ECONOMIC.SECTION)=""""))

The reason is that you need to wrap the quotation mark in two quotation marks so that it is seen as text and then add another one

 

[dgriffis1231]

That worked! Thanks CJ