Dang Anh Dang Anh - 1 month ago 8
MySQL Question

How to covert INT to VARCHAR in SQL condition

select...
from...
where R.WORK_YM = 201611

how to change R.WORK_YM to String value?

Answer

Try this:

select... from... where cast(R.WORK_YM as varchar(10))= '201611'