IsNull and Is Null

[SadAko]

Hi! I'm just curious what is the difference between IsNull without a space and Is Null with the space? Thanks!

[autonumber]

Hi there! IsNull is when there is value to return. It Replaces NULL with the specified replacement value, otherwise returns the result of expression.. While Is Null with the space is when you just want to check if there is a blank value. 

You can check this link https://howto.caspio.com/function-reference/

[telly]

Hi @SadAko,

The difference between IsNull and Is NULL, We use IS NULL to identify NULL values in a table. ISNULL() function lets you return an alternative value when an expression is NULL.

For reference you can check these links:
- https://www.w3schools.com/sql/sql_isnull.asp
- https://www.sqlshack.com/sql-isnull-function-2/

[NiceDuck]

In regards with 'IS NULL', you can actually try using  ( = '' ) as well.

ex.
Where [@field:name]  IS NULL

Where [@field:name] = '' 

[RuisiHansamu]

There is a similar forum post that can be very helpful here: