NULL Concatenation Behavior Property
The NULL Concatenation Behavior property specifies how the data source handles the concatenation of NULL-valued character data type columns with non–NULL-valued character data type columns.
Applies To
| Connection Object |
Syntax
object.Properties("NULL Concatenation Behavior")
Parts
object
Expression that evaluates to an object in the Applies To list.
Returns
One of the following settings:
| Constant | Description |
|---|---|
| DBPROPVAL_CB_NULL | The result is NULL valued. |
| DBPROPVAL_CB_NON_NULL | The result is the concatenation of the non–NULL-valued column or columns. |
Data Type
adInteger
Modifiable
Read-only
OLE DB Property
DBPROP_CONCATNULLBEHAVIOR