No accounts returned when using starting postal code beginning with 0 in postal code radius query

When using the criteria for postal code radius in a query, if the starting postal code field has a postal code that begins with 0, no accounts are returned regardless of the radius entered. If you edit the query to remove the leading 0 from the postal code and keep the radius the same, then the query results will return accounts outside of the radius entered. 
We are currently evaluating this issue and will update this article when we have more information.

Steps to Duplicate

  1. Create a new query
  2. Select query category of base and set query to all constituents
  3. Choose data return type of accounts for results 
  4. Set criteria matching to match all criteria and leave drop down as any persona
  5. Add criteria for postal code radius. 
  6. Enter a postal code that begins with 0 in starting postal code
  7. Enter any radius greater then 1
  8. Click save and preview
  9. No accounts returned
  10. Select edit query
  11. Remove the leading 0 from the postal code and leave radius the same
  12. Select save and preview.
  13. The results returned are not within the radius of the postal code


 Chrome;Firefox;Internet Explorer

Was this article helpful?