General information
Category:
Coding, syntax & commands
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only