Re: Using " in an External () query

2012-08-09 Thread patchsk
For the internal double quotes I think you need to use four quotes like as below "NOT ('Project Status' =" + + "Completed" + + " OR 'Project Status' = " + + "Cancelled" + . On Thursday, August 9, 2012 11:17:28 AM UTC-7, Vimal wrote: > > Hi all, > > Please assist, >

Re: Using " in an External () query

2012-08-09 Thread Grooms, Frederick W
t; OR 'Project Status' = ""Closed"" OR 'Project Status' = ""Failed"")" -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk Sent: Thursday, August 09, 2012 1

Re: Using " in an External () query

2012-08-09 Thread patchsk
Sorry for the typo. I meant two double quotes(not four single quotes). You need to double it as the other post. On Thursday, August 9, 2012 11:41:12 AM UTC-7, patchsk wrote: > > For the internal double quotes I think you need to use four quotes > like as below > > "NOT ('Project Status' ="

Re: Using " in an External () query

2012-08-09 Thread Grooms, Frederick W
quot; + $MyField2$ + """" + ")" Or "NOT ('Project Status' = """ + $MyField1$ + """ OR 'Project Status' = """ + $MyField2$ + """)" Fred -----Original Message- From: