# NULL Values

**URL:** <https://forum.inductiveautomation.com/t/null-values/1609>\
**Category:** Ignition\
**Created:** [March 5, 2010, 5:13pm UTC](https://forum.inductiveautomation.com/t/null-values/1609 "2010-03-05T17:13:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bryan\_cook](https://avatars.discourse-cdn.com/v4/letter/b/a8b319/32.png) [@bryan\_cook](https://forum.inductiveautomation.com/u/bryan_cook)\
**Post date:** [March 5, 2010, 5:13pm UTC](https://forum.inductiveautomation.com/t/null-values/1609/1 "2010-03-05T17:13:18Z")

</div>

Can I pass a NULL value to an input parameter of a stored procedure using the SQL Bridge Module and a Stored Procedure Transaction Group?

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [March 5, 2010, 10:53pm UTC](https://forum.inductiveautomation.com/t/null-values/1609/2 "2010-03-05T22:53:22Z")

</div>

Unfortunately, it appears that it’s not currently possible to pass a null. All item values are “coerced” to their specified data types in such a way that nulls are converted to the default value of the type. This should be changed soon, because it’s different than how FactorySQL did it.

For example, it should be possible to create an expression item whose expression was simply the keyword “null”. Currently even this will be converted to “” if the item is a string. That doesn’t make much sense. It will be modified for version 7.0.5.

Regards,