Hello @garb,  Thanks for being part of our community.  I was reviewing the information and even though Calcite is the engine used for the SQL, looks like not all the queries are supported officially.  Looking in several places, I do not see LPAD used anywhere.  But something that may work for what you need is CONCAT, which should give you the correct format properly and is broadly used in the community:  SELECT MsgSeqNbr, PostTime, SSN, EmployeeID, LName, FName, MName, CAST(TRIM(LCN) AS BIGINT) AS LCN, RIGHT(CONCAT('00000', PIN), 5) AS PIN, EmployeeType, ValidityCode, AgencyOwner, AgencyLocated, BadgeCreatedBy, BadgeCreatedTime, BadgeModifiedBy, BadgeModifiedTime, Clearance, Error, Status FROM FLOWFILE Based on the error "No match found for function signature LPAD" it looks like the engine configured for NiFi does not support LPAD even when Calcite do support it.  I was trying to find on the code the supported functions, but did not find LPAD.  This looks to be the most accurate reference we have where we do see CONCAT: https://github.com/apache/nifi/blob/main/nifi-docs/src/main/asciidoc/record-path-guide.adoc  ... View more