I have a label that pulls a fixed 5 digit store number from my SQL database that uses leading zeros (i.e store #4 = 00004, store # 222 = 00222).   With a different customer, the label had been setup to add preceding zeros, now I want to remove all zeros so that I only get 3 digits.  Here's my thinking, but something isn't working.

local numberVar v_length := 0;
local stringVar v_store := "";

// get the length of the store number field
v_length := Length({customer.strnum});

// evaluate the store number length, if less than three, append zeroes at the beginning
if (v_length = 3) then
    v_store :={customer.strnum}
else if (v_length = 2) then
    v_store :="0" + {customer.strnum}
else if (v_length = 1) then
    v_store :="00" + {customer.strnum}
else
    v_store := "000";

v_store;

Why not use

Edited by DBlank - 22 Jun 2009 at 2:11pm