Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to restrict a resident load to where a particular field is null.
I've tried
RESIDENT TableName
WHERE NOT FieldToCheck IS NULL;
But this didn't work.
I can't do the restriction in the sql load statement, since I need the cases where the field is null to be present in another resident load.
Any help would be appreciated.
Perhaps try something like:
Resident TableName
Where Len(FieldToCheck)>0;
Perhaps try something like:
Resident TableName
Where Len(FieldToCheck)>0;
Worked great thanks.
Why not do this:
Resident TableName
WHERE not IsNull(FieldToCheck);
I believe the "IsNull" function is less expensive than the "Len" function.
Hey Jeff,
That should give the same result and might cost less as you say.
The reason that me, and several others are hooked on the len() function is that there used to be a difference.. back in early QV 8 if I remember correctly, where the results from IsNull() varied based on your platform (32 vs 64 bit) while len() was consistent.
These days, IsNull() should be the easier option.
Cheers,
Johannes
where IsNull(num([field]))=0
😉