Export (0) Print
Expand All
Expand Minimize

ContactNull Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The ContactNull property specifies NULL-value handling for catenation.


object
.ContactNull [=value]

object

An expression that evaluates to an object in the Applies To list

value

TRUE or FALSE

Boolean

Read/write

HRESULT GetContactNull(LPBOOL pRetVal);
HRESULT SetContactNull(BOOL NewValue);

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.

Community Additions

ADD
Show:
© 2014 Microsoft