Subject | Expecting "" value back, receiving System.DBNULL |
---|---|
Author | David Wessell |
Post date | 2007-06-21T21:02:48Z |
Hi,
I'm writing a SELECT query, and sometimes the results of one of the
fields that is queried is empty.. I was expecting a empty string value
to be returned (Writing in Visual Basic, using ODBC BTW)..
However, the result returned when that field is empty is
System.DBNULL.. Can someone point me in the direction as to why I
would receive this?
Other fields in the query that are empty are returning empty strings,
it's just this one field..
Thanks
David
I'm writing a SELECT query, and sometimes the results of one of the
fields that is queried is empty.. I was expecting a empty string value
to be returned (Writing in Visual Basic, using ODBC BTW)..
However, the result returned when that field is empty is
System.DBNULL.. Can someone point me in the direction as to why I
would receive this?
Other fields in the query that are empty are returning empty strings,
it's just this one field..
Thanks
David