Can't see the problem here? Having a bad day. Anyone make this work for me?
SELECT D399M.HESA_YEAR, D550M.EMPLOYEE_NUMBER, D500M.SURNAME, D399M.HESA_REC_ID, Substring([D399M.HESA_CONTRACT_ID],1,5) AS
Expr1, Len(RTrim([D399M.HESA_CONTRACT_ID])) AS CtractID_Length_, IIf([CtractID_Length_]= '13'...