$NULL$
'Status' < "Closed" AND ('Assigned Person' != "Mark Brittain" OR 'Assigned
Person' = $NULL$)
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Elry
Sent: Monday, March 14, 2011 2:40 PM
To: arslist@ARSLIST.ORG
Subject: Re: Question about NULL
Just a quick question Mark...
Did you mean $NULL$ OR NULL.
On Mar 14, 2:05 pm, "Brittain, Mark" <mbritt...@navisite.com> wrote:
> HI All,
>
> I have a table that uses the following query which searches for any open
> record that is not assigned to me.
>
> 'Status' < "Closed" AND ('Assigned Person' != "Mark Brittain" OR 'Assigned
> Person' = NULL)
>
> If I use the query without the Assigned Person' = NULL the result does not
> include any records that are not assigned. Both fields are indexed but the
> NULL causes the full table scan. Is there a way to write query so that
> indexing is used but I get the records that are unassigned?
>
> Thanks
> Mark
>
> ____________________________________________
> Mark Brittain
> Remedy Developer
> NaviSite
> mbritt...@navisite.com<mailto:mbritt...@navisite.com>
> (315) 453-2912 x5335 (Office)
> (315) 317.2897 (Cell)
>
> ________________________________
> This e-mail is the property of NaviSite, Inc. It is intended only for the
> person or entity to which it is addressed and may contain information that is
> privileged, confidential, or otherwise protected from disclosure.
> Distribution or copying of this e-mail, or the information contained herein,
> to anyone other than the intended recipient is prohibited.
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug11www.wwrug.comARSList: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
