Paytronix is using this block, and tried to filter on zips that start with 0. The block is pulling them as numbers and omitting this leading zero, meaning these zips are all being displayed as four digits, and filtering on "starts with zero"
fails to find anything.
Client tracked the issue doe to zips being pulled in with: RPAD(CAST(${TABLE}.zip_code AS varchar), 5, '0'), which he believes should be LPAD instead so the zero is in the front.
Paytronix is using this block, and tried to filter on zips that start with
0. The block is pulling them as numbers and omitting this leading zero, meaning these zips are all being displayed as four digits, and filtering on "starts with zero"fails to find anything.
Client tracked the issue doe to zips being pulled in with:
RPAD(CAST(${TABLE}.zip_code AS varchar), 5, '0'), which he believes should beLPADinstead so the zero is in the front.