I need help in identifying bad data(PERSON_NAME) from below select query due to which query is failing as it is not able to parse FIRST_NAME & LAST_NAME.
SELECT
PERSON_NAME
,Trim(OReplace(PERSON_NAME,StrTok(PERSON_NAME,' ',1),'')) AS AGENT_LAST_NAME
,StrTok(PERSON_NAME,' ',1) AS AGENT_FIRST_NAME
FROM TABLENAME
WHERE CAST(RECORD_START_TS AS DATE) = '2022-11-01';
*** Failure 6706 The string contains an untranslatable character.
Actual Output should look like below:
PERSON_NAME AGENT_LAST_NAME AGENT_FIRST_NAME
Abraham Gomezfitzgerald Gomezfitzgerald Abraham
Adam Tregoning Tregoning Adam
Ajiel Marino Marino Ajiel
Alexander Ford III Ford III Alexander
Fernanda Garvey Hernandez Garvey Hernandez Fernanda