• If you want a generic function you could do it like this:

     
    
    SET field_name = RIGHT(REPLICATE('0',5) + field_name,5)

    -Dan


    -Dan