NULL Collation Order Property
The NULL Collation Order property indicates how NULLs are sorted in a list.
Applies To
| Connection Object |
Syntax
object.Properties("NULL Collation Order")
Parts
object
Expression that evaluates to an object in the Applies To list.
Returns
One of the following settings:
| Constant | Description |
|---|---|
| DBPROPVAL_NC_END | NULLs are sorted at the end of the list, regardless of the sort order. |
| DBPROPVAL_NC_HIGH | NULLs are sorted at the high end of the list. |
| DBPROPVAL_NC_LOW | NULLs are sorted at the low end of the list. |
| DBPROPVAL_NC_START | NULLs are sorted at the start of the list, regardless of the sort order. |
Data Type
adInteger
Modifiable
Read-only
OLE DB Property
DBPROP_NULLCOLLATION