I'm trying to use EQNULL set ON to help me solve a programming problem. I'm doing a SELECT like this (this is a simplified version, yes I know I could just code this select a little differently, but in the real code I can't predict whether I will have a NULL value or not):
SELECT * FROM MyTable WHERE MyIntegerColumn = .vMyNullVariable My undestanding is that (giving vMyNullVariable is an INTEGER set to NULL) that with EQNULL set ON I should get back rows where MyIntegerColumn contains NULL values and with EQNULL set OFF I should get back no rows. Unfortunately, with EQNULL set ON, I get the error MISSING RIGHT SIDE OF COMPARISON (almost as if I had used the & and the the . before the variable). This only happens with NULL set to ' ' (blank). If I SET NULL -0-, the command returns rows properly. Has anyone else observed this? -- Larry
