THE STRING CONTAINS an UNTRANSLATABLE CHRACTER 6706 SELECT FAILED

General

THE STRING CONTAINS an UNTRANSLATABLE CHRACTER 6706 SELECT FAILED

SELECT COUNT(DISTINCT RP.MY_ID), CAST (RP.MY_DATE AS DATE)

FROM

iCM_LOAD.MY_TBL RP

INNER JOIN

iC.MY_PRGM MP

ON RP.MY_PRGM_NBR = MP.MY_PRGM_NBR

INNER JOIN

iC.EMAIL_ADDR RPE

ON RP.MY_ID = RPE.MY_ID

AND RP.MY_PRGM_NBR = RPE.MY_PRGM_NBR

WHERE

RP.MY_PRGM_NBR (220)

AND RPE.SU_OP_IN = ‘O’

AND RP.MY_DATE BETWEEN ’2013-07-31′ and ’2013-08-07′

GROUP BY CAST ( RP.MY_DATE AS DATE)

ORDER BY CAST (RP.MY_DATE AS DATE)

Please use translate_chk function to determine untranslatable column values that are causing this issue--> How do I use this in my Query?

WHERE TRANSLATE_CHK(Field Name USING LATIN_TO_UNICODE) <> 0;

How do I determine What field string value has issue in my query?

I am lost. 

Kindly help

thanks