ContactNull Property (SQL-DMO)

The ContactNull property specifies NULL value handling for catenation.

Applies To

DBOption Object

Syntax

object.ContactNull [= value]

Part Description
object Expression that evaluates to an object in the Applies To list
value True or False

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.

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetContactNull(LPBOOL pRetVal);

HRESULT SetContactNull(BOOL NewValue);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.