> For the complete documentation index, see [llms.txt](https://200ok.gitbook.io/200ok-documents/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://200ok.gitbook.io/200ok-documents/user-manual/built-in-functions/logical/isnull.md).

# isNull

isNull() function is the Standard function available in 200OK.

**Description** : The isNull function checks whether an expression is null and returns TRUE or FALSE accordingly.

**Syntax** : fx\_isNull(expression)

**Example** : fx\_isNull(null) returns true, while fx\_isNull(10>11) returns false.

\
Here we go with simple scenario using the above function.

**Scenario** : In a database query, a software developer is validating data retrieved from a database before further processing. They utilize a function to check if the retrieved data is null. If the data is null, the system handles it differently than if it contains valid information.

<br>

**Request Side** :&#x20;

<figure><img src="https://lh7-us.googleusercontent.com/h4OyWpLyru7qXq64c8c64mb0PMOsNShLQIEIlztEzAcGd84kQu3vvT4FtsBPTeIMIc7jlzxOiHbwdpXeTu_gbi5-7onMxV-cPIKGGaOhMsOTOdLCcxpVO_UzTSwelsHJ_XzCej95kzbvMIkcED2D3ug" alt=""><figcaption></figcaption></figure>

<figure><img src="https://lh7-us.googleusercontent.com/5ZUiWsMXaRZmnaMyAmOZeAdax1OvLruzYSAikX1GoFtsWOmlr8-syHroDtwpgjZ6nNekQPt_9EiHMGLoUFPfF4yMOWba2pgO--wyQKgephCDLxCn0GVcUM6q5csgnceABqRA87ekaTvu7WQ-SIeQcQg" alt=""><figcaption></figcaption></figure>

<br>

<figure><img src="https://lh7-us.googleusercontent.com/u4OVC2RU7IQ4_sdVKrawWqh4CDUX_yz-gNAIcfKNHws9z8UHdYhhEIgVlWBUuZeM9XdqGsmOzZAuBt6qlXYjtd6_7G7YCrltpgW2qNDUPw12gNl5JIUFf79frYs7NzOrfwz1xgawx0GZTf9fjnM9nYE" alt=""><figcaption></figcaption></figure>

<figure><img src="https://lh7-us.googleusercontent.com/Xpx58YgHrBYu4LTYvTr7nxzBvRf0N85uwCOWm-HtZQpzu39wKn1r06qoGdorbR6xh35ulnydU78upjg9JyJOwOW7ENPLNm-kosjQHZ3nBe-MmD4iOLOieTp23Ggt5QA9Ff0xQeyk08R3Rg_5kyhX8nk" alt=""><figcaption></figcaption></figure>

**Response Side** :&#x20;

<figure><img src="https://lh7-us.googleusercontent.com/KYCi73nr5YZftCy6-xd3yL_hGEF210lVevhRVKYaEKSmLJ1bEo9455RPkLHeIFqZdwIPKWRbx9ETwbYbl_51Ot7Xk9gJBSoYG4O-j7z-wsvZJQgixBCrZPrmxVGOv3p-uALfUUYqSimn1JdZXrk6i4E" alt=""><figcaption></figcaption></figure>

<figure><img src="https://lh7-us.googleusercontent.com/xQv_1hO-nNFNSqCF7f81gIgxWBqENIZMyrAwOP0yP5TKICLT1rHuy3FZW_7NEE7QQw4Sc94jM5rrq8eAO0Yv5ABK3V3DheznUYtwz6Rr80GwDYVAJoky7YZe1oZ30b2V7AEbgogGBy1icih8Cp6pTGw" alt=""><figcaption></figcaption></figure>
