Page 1 of 1
not returning null values
Posted: Wed Aug 23, 2006 8:06 pm
by GeXus
how do you not return null values?

Posted: Wed Aug 23, 2006 8:08 pm
by feyd
By not storing them, by filtering them out in the where clause.. can you be a bit more specific?
Posted: Wed Aug 23, 2006 10:03 pm
by paladaxar
WHERE field_name IS NOT NULL;
Is that what you were looking for? Like feyd said, can you be a bit more specific? Just make sure you are not using equality with null's. Nothing is ever equal to null, nor can anything be greater than or less than null. It just is or it isn't.