ADO and SQL Server

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