| **Navigation:**  [[introduction.htm|Language Reference]] > 13 - Built-in Functions >====== SETNULLS(set the null state of columns) ====== | [[setnull  set file field null .htm|{{btn_prev_n.gif|Previous page}}]][[introduction.htm|{{btn_home_n.gif|Return to chapter overview}}]][[setpath  change current drive and directory .htm|{{btn_next_n.gif|Next page}}]] |
|  ||

{{newc7.jpg|NewC7.jpg}}

**SETNULLS(**//table//, //null-value//**)**

{{blk2blue.jpg|blk2blue.jpg}}

| **SETNULLS** | Set NULL state of columns in a table. |
| //table// | The label of a FILE. |
| //null-value// | Null "value" to assign to the table. |

**SETNULLS** sets the NULL state of every column in the table based on the contents of the passed string. The passed string must be obtained from a prior call to GETNULLS. This function is valid on all SQL table types.

**Errors Posted:**

| 75 | Invalid Column Type Descriptor ' Indicating that the passed string was too small. |
| 80 | Function Not Supported |

**Example:**

**StorageString STRING(255)**

**Rec           STRING(2048)**

**  CODE**

**  StorageString = GETNULLS(table)  !Get NULL state of table**

**  Rec = table.record               !Save record buffer**

**  ! Do Table Processing**

**  Table.Record = Rec               !Restore record buffer**

** ****SETNULLS****(table, StorageString)   !Set NULL state of table columns**

**See Also:**

[[getnulls get the null state of a table .htm|GETNULLS]]

[[null  return null file field .htm|NULL]]

[[setnonull  set file field non null .htm|SETNONULL]]