Information générale
Catégorie:
Codage, syntaxe et commandes
Hi Ed,
WOW! Thanks. I wasn't even going to try to format for the Canadian zips yet. My old mask was '99999-9999' and that didn't allow for the alpha in the Canadian zips, so they couldn't enter them. I didn't know the actual format of the Canadian zip anyway - 'til now thanks to you. This does muddy the waters slightly though: not all US zips will have 9 digits, some will be just 5. Hence I can't arbitrarily use the !9!9!9 mask if less then 9 digits. Maybe IF LEN(RTRIM(zip_code)) = 5 OR LEN(RTRIM(zip_code)) = 9 US Format ELSE Canadian format.
Thanks again. Have a nice day. Don't let the Love Bug Bite.
Regards,
Paige
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement