For the sort code you can use the below in a calculation for the insight report:
LPAD(PRCI_HR_PERSON_MASTER.BANK_SORT_CODE, 6, 0)
This means left pad sort code to 6 characters and use 0 if there is not 6 being returned.
Insight report leading zeros
Need to Keep Leading 0 on CSV Export from Insight for sort codes and bank accounts.
J
Written by Joshua Shooter
Updated over 2 months ago