Date: Thu, 9 Sep 2010 18:54:40 -0400
Reply-To: Arthur Tabachneck <art297@NETSCAPE.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Arthur Tabachneck <art297@NETSCAPE.NET>
Subject: Re: Access "IN(IS NULL, '2' " question........
Have you tried something like?:
libname x "c:\db1.mdb";
Where missing(variable) or variable in ("2");
On Thu, 9 Sep 2010 14:43:03 -0500, Craig Johnson <cjohns38@GMAIL.COM>
>Is there a trick to getting the IS NULL option to pass through to access
>work in an IN operator? For example.......
>Where Variable In(Is Null, '2');
>I can't figure out how to get it work or if it is even possible (
>http://www.devx.com/vb2themax/Tip/18541). Yes, I realize I could rewrite
>the code a couple of different ways it just seems like I should be able to
>add the "Is Null" option in.............