# Null in Data Grid

**URL:** <https://forums.toadworld.com/t/null-in-data-grid/7228>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [April 24, 2012, 8:04am UTC](https://forums.toadworld.com/t/null-in-data-grid/7228 "2012-04-24T08:04:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![AdamS](https://avatars.discourse-cdn.com/v4/letter/a/96bed5/32.png) [@AdamS](https://forums.toadworld.com/u/AdamS)\
**Post date:** [April 24, 2012, 8:04am UTC](https://forums.toadworld.com/t/null-in-data-grid/7228/1 "2012-04-24T08:04:08Z")

</div>

When using Teradata the results grid as well as the Data tab in Data Explorer show NULL values as blanks rather than {null}. Is there a way to make TDA display the NULL values as {null} or another character rather than blank?

---

<div class="post-metadata">

**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\
**Post date:** [April 24, 2012, 1:23pm UTC](https://forums.toadworld.com/t/null-in-data-grid/7228/2 "2012-04-24T13:23:00Z")

</div>

Could you please provide the table DDL that shows null as a blank?I’ve re-checked and for number and varchar columns we show null as {null}.