Please let me know what is wrong with the below query. I get a message saying function is missing a comma.
SELECT ALL; XPAT.PAT_ID AS PAT_ID_X,; IIF(XPAT.TMPATINFO like '4000%', XPAT.PAT_ID, XPAT.TMPATINFO),; XPAT.TMPATINFO AS XTMPATINFO; FROM "XPAT" XPAT; INTO CURSOR EA_T