Hi all,
I’ve got a SQL problem that’s stumping me. I have an employee table with a field labeled:
Emp_terminated DATE
Obviously, some employees in this table won’t have this field set. I want a query to select only employees without this field being set, ie., only current employees. I’ve got the inverse working by using:
SELECT * FROM employee WHERE ISFINITE(emp_terminated);
And that gives me all the old employees (where the field has a value), but for the life of me, I can’t figure out the syntax to use for employees that haven’t been terminated or quit. Everything I’ve tried returns no rows.
Anybody?
--
John
