SQL.GetParamIsNull
------------------

Whether the parameter value is NULL.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [SQL](component_SQL.md) | [2.6](newinversion26.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "SQL.GetParamIsNull"; Command; Param ) 

**MBS**( **"SQL.GetParamIsNull";** /\* Whether the parameter value is NULL. \*/  
**$Command**; /\* The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). \*/   
**$Param**) /\* The parameter name or ID. Pass number for ID, a text with parameter name or the index with # prefix. e.g. "#0" for first parameter.e.g. "1" \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| Command | The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). | $Command |
| Param | The parameter name or ID. Pass number for ID, a text with parameter name or the index with # prefix. e.g. "#0" for first parameter. | "1" |

### Result

Returns 1 if the value of current object is NULL; otherwise 0.

### Description

Whether the parameter value is NULL.  
### See also

- [SQL.GetParamAsDate](SQLGetParamAsDate.md)
- [SQL.GetParamAsJPEG](SQLGetParamAsJPEG.md)
- [SQL.GetParamAsNumber](SQLGetParamAsNumber.md)
- [SQL.GetParamAsPNG](SQLGetParamAsPNG.md)
- [SQL.GetParamAsText](SQLGetParamAsText.md)
- [SQL.GetParamAsTime](SQLGetParamAsTime.md)
- [SQL.GetParamIsDefault](SQLGetParamIsDefault.md)
- [SQL.GetParamValue](SQLGetParamValue.md)
- [SQL.NewCommand](SQLNewCommand.md)
- [SQL.SetParamNull](SQLSetParamNull.md)

This function is free to use.

Created 18th August 2014 , last changed 28th November 2019

  
[SQL.GetParamIsDefault](SQLGetParamIsDefault.md) - [SQL.GetParamName](SQLGetParamName.md)

[HTML Version](SQLGetParamIsNull.shtml)