Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
Are the contacts where '"CompanyName" = null' individual or non-individual contacts?
CompanyName is only set when it is not an individual contact i.e. "IsIndividual" = false
FirstName, LastName are set when it is an individual contact i.e. "IsIndividual" = true
I have never come across that before however when the word is Googled it says"Null is a special marker used in Structured Query Language (SQL) to indicate that a data value does not exist in the database"?
So I don't no whether that helps in your query?
We have a customer with company file id xxxxxx .
When we request contacts, we get few of them with Company Name = NULL. How is that possible?
Any help will be much appreciated
Solved! Go to Solution.