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.