SQL-DMO

ContactNull Property

The ContactNull property specifies NULL value handling for catenation.

Applies To
DBOption Object

Syntax

object.ContactNull [= value]

object

Expression that evaluates to an object in the Applies To list

value

TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetContactNull(LPBOOL pRetVal);

HRESULT SetContactNull(BOOL NewValue);

Remarks

If TRUE, A + NULL, where A is a string, yields NULL.

If FALSE, A + NULL, where A is a string, yields A.

Any value for ContactNull is overridden by the AnsiNulls property which controls NULL catenation behavior for a client session.