nyucknyucknyuck
Technical User
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!
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!