Re: what's the difference between VT_NULL and VT_EMPTY

From: Jeremy Collins (jd.collins_at_ntlworld-not.com)
Date: 02/14/04 

Date: Sat, 14 Feb 2004 12:55:06 +0000

Phili wrote:

> Why dont you tell us the context?
>
> There does nit seem to be any thing in SQL Server by the name VT_EMPTY / VT_NULL

They are nothing to do with SQL Server; FWIW VT_EMPTY
is part of the VARTYPE enumeration used to specify variant
datatypes (typically with the COleVariant MFC class).

VT_EMPTY means "not specified" and has a value of 0, while
VT_NULL means null, and has the value 1. 

-- 
jc
Remove the -not from email