I have to retrive name for an employee who joined this year
Employee number is 15 digit character. first 2 digits of employee number contains year of joining
querry is like this
select empl_name from emp where empl_no= ?
i am using:
empl_no like (CHAR(MOD(YEAR(CURRENT DATE),100)))
function (CHAR(MOD(YEAR(CURRENT DATE),100))) returns 15 but like operator is not accepting it