datatype

[fmardani]

Hi,
My question is to do with the datatype?
In the constructor of a class, I am initializing the variables which are of various types (i.e: string, double, decimal, etc...)
These are initialized such as "" for string and 0 for int or 0 for double, etc...
Let's say that during a call to the DB, only one of them gets set (i.e: the string variable = "hello") but the other variables are not set. So obviously the other variables are set to 0 of they are decimal for example.
The question is that how is it possible to find out that the other variables that were not set?. I.e: how can I return null for the other variables?

Hope this is clear
Thanks

[nswan]

use an inline iif statement when returning values

iif(intNum = 0, system.dbnull, intNum)

[Pirate]

Or more flexible , create two or three constructors with different variable declarations .