# boolean?

**URL:** <https://forum.servoy.com/t/boolean/5671>\
**Category:** Classic Servoy\
**Created:** [April 2, 2006, 7:39am UTC](https://forum.servoy.com/t/boolean/5671 "2006-04-02T07:39:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![antonio](https://avatars.discourse-cdn.com/v4/letter/a/6de8d8/32.png) [@antonio](https://forum.servoy.com/u/antonio)\
**Post date:** [April 2, 2006, 7:39am UTC](https://forum.servoy.com/t/boolean/5671/1 "2006-04-02T07:39:02Z")

</div>

What’s the recommended data type to create to handle boolean fields, so they can be most easily referenced in a method?  
I’m guessing integer, but I’m (obviously) new to Servoy and SQL.

---

<div class="post-metadata">

**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\
**Post date:** [April 2, 2006, 7:41am UTC](https://forum.servoy.com/t/boolean/5671/2 "2006-04-02T07:41:15Z")

</div>

We are using integers. A 1 is “true”, everything else (NULL, “0”) is false. In a Servoy method you can simply ask

```auto
if (column)

```

to check for the 1.

---

<div class="post-metadata">

**Author:** ![bcusick](https://avatars.discourse-cdn.com/v4/letter/b/ed8c4c/32.png) [@bcusick](https://forum.servoy.com/u/bcusick)\
**Post date:** [April 3, 2006, 6:37pm UTC](https://forum.servoy.com/t/boolean/5671/3 "2006-04-03T18:37:16Z")

</div>

Additional Information:

```auto
if(column)
{

}

```

Will evaluate to TRUE for NOT NULL and NOT EMPTY.