List:General Discussion« Previous MessageNext Message »
From:Scott Haneda Date:June 26 2006 11:16pm
Subject:Leading zero where strlen < 5
View as plain text  
I need to update a column, if the string length is less than 5, I want to
add leading zeros to it until it has 5.  These are zip codes, I think there
are no 00 leading zips, so most should all be four chars long.
-- 
-------------------------------------------------------------
Scott Haneda                                Tel: 415.898.2602
<http://www.newgeo.com>                     Novato, CA U.S.A.


Thread
Leading zero where strlen < 5Scott Haneda27 Jun
  • RE: Leading zero where strlen < 5J.R. Bullington27 Jun
    • Re: Leading zero where strlen < 5Mike Wexler27 Jun
      • Re: Leading zero where strlen < 5Scott Haneda27 Jun
  • Re: Leading zero where strlen < 5Joerg Bruehe27 Jun
    • Re: Leading zero where strlen < 5Scott Haneda28 Jun