http://forums.method.me/cs/forums/15.aspxAsk questions specific to the MethodAPI from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/36073.aspxThu, 18 Jul 2019 20:42:48 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:36073boblaw0http://forums.method.me/cs/forums/thread/36073.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=15&PostID=36073<p><span id="mce_0_start" style="overflow:hidden;">Perfect. Thanks Hossein</span></p>http://forums.method.me/cs/forums/thread/36070.aspxThu, 18 Jul 2019 19:17:54 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:36070Method_Hossein0http://forums.method.me/cs/forums/thread/36070.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=15&PostID=36070<p><span id="mce_0_start" style="overflow:hidden;">Try using: </span></p> <p><span id="mce_0_start" style="overflow:hidden;">SalesRep IS NULL</span></p>http://forums.method.me/cs/forums/thread/36069.aspxThu, 18 Jul 2019 15:55:20 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:36069boblaw0http://forums.method.me/cs/forums/thread/36069.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=15&PostID=36069<div class="intercom-p2jv6n e1iwlnx70 intercom-conversation-part-enter-done"> <div class="intercom-n338es elc4fgv0"> <div class="intercom-comment intercom-19zjfjz e28em7w1"> <div class="intercom-blocks"> <div class="intercom-block intercom-block-paragraph intercom-rtmz9l">I am using your API and running a query on our customer table to locate accounts where a specific field is blank (salesrep). I am unable to pull &quot;blanks&quot; or &quot;Null&quot; values. Is there a specific method to return empty fields via your API? Is there a LEN() function in your API strWhereClause?</div> </div> <div class="intercom-vpclar e1oluflk1"> <div class="intercom-7yjdbr eknz5wz1"></div> </div> </div> </div> <div></div> </div> <div class="intercom-cuxqhq e1iwlnx70 intercom-conversation-part-enter-done"> <div class="intercom-skmhbj elc4fgv0"> <div class="intercom-comment intercom-1psh5q2 e28em7w1"> <div class="intercom-blocks"></div> </div> </div> </div>