IIF Character Count

[nyucknyucknyuck]

For some reason all of the zip codes that begin with zero have been imported into my database WITHOUT the zero.

I don't know SQL, I use the MS Access query builder; I am trying to write a query That says (using the IIF statement

IIF zip code is less than 5 digits/characters then "0"&[ZipCode]

But I don't know the function to use.

Thanks in advance!

 

[PWise]

dont use iif
use

format(zipcode,"00000")

 

[nyucknyucknyuck]

FYI Found it in another post.

IIF(Len([PostalCode])=4,"0"&[ZipCode],[ZipCode])

 

[nyucknyucknyuck]

pwise (Programmer) ,

I have some 10-digit zips in the dbase, so I had to look only at the 4-char count.

Thanks anyway.