What is the use of the ISNULL operator?
The ISNULL operator is used to test the null state of character and numeric variables. This new variable state was added for support of SQL. SQL character and numeric values can have the null value. Thus when reading data from an SQL database, the DB/C variables are set to the null state if the source value is null. Likewise, when writing to an SQL database, if the source DB/C variable is null, then the value stored in the database is null. Note that the null state is different from the DB/C character variable value of zero length (the formpointer is zero) and the DB/C numeric variable value 0.
Related Questions
- Ive been using the IsNull function but it seems to be ignoring the second parameter (just returning True or False instead). Is this function supported and/or is there an alternative?
- How does the operator measure the thickness of a wall plus all the layers of plaster added over the years?
- How do hold bees away from chunky machinery and its operator?
