IBM Mainframe Forum

Hi,

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
e.g: 1434234235345345452
1523234234234234453

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

pls help!