Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
NetSuite Admin Tip | Using COALESCE to Manage Null Customer Phone Numbers
When working with SuiteQL queries, you may notice that some fields return null values if no data has been entered. For example, if a Customer doesn’t have a phone number on record, the query output for that field will simply be blank. While technically correct, blank values can make reports harder to read and may cause issues when exporting or integrating data with other systems.
To make your query results more meaningful and user-friendly, you can use the COALESCE() function. This function allows you to replace null values with a default value of your choice—such as "Not Provided," "N/A," or even a placeholder number.
Richard James Uri - SuiteCloud | WMS Tech | SuiteCommerce Advanced
----
- NetSuite Admin Corner | New to NetSuite
- Explore the NSC Webinars Category
- Join our poll and share your ideas! We want to know what you think. Don't forget to comment and make your voice heard!
- Expand your NetSuite knowledge by joining this month's Ask A Guru Live about Suitebuilder . RSVP on this event now!
Tagged:
0