Method Community

 

Finding a blank

Last post 07-18-2019 3:42 PM by boblaw. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 07-18-2019 10:55 AM

    • boblaw
    • Not Ranked
    • Joined on 06-05-2019
    • Posts 3

    Finding a blank

    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 "blanks" or "Null" values. Is there a specific method to return empty fields via your API? Is there a LEN() function in your API strWhereClause?
  • 07-18-2019 2:17 PM In reply to

    Re: Finding a blank

    Try using:

    SalesRep IS NULL

  • 07-18-2019 3:42 PM In reply to

    • boblaw
    • Not Ranked
    • Joined on 06-05-2019
    • Posts 3

    Re: Finding a blank

    Perfect. Thanks Hossein

Page 1 of 1 (3 items)