SELECT * FROM EMPLOYEE WHERE CONCAT(VALID, 'Y') != 'N'
SELECT * FROM EMPLOYEE WHERE NVL(VALID, 'Y') != 'N'