How to break zipcodes fileds with leading zeros

Question

How to break zipcodes fileds with leading zeros

Viewing 2 posts - 31 through 31 (of 31 total)

You must be logged in to reply to this topic. Login to reply

ScottPletcher SSC Guru Points: 101095 More actions · Answer 1

I think it's just this specific thing that bothers me: the first digit of a zip code is meaningless in a business context.

That's why I just can't see myself building a table around it.

SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 2

Dunno if it helps or not but I do agree that this specific thing smells fishy to begin with. And I wouldn't make the table... I would force someone else to make it and populate it according to the standard auditable practices that every company has. That might make people thing about this crazy requirement a bit more.

In truth, though, I think the only real requirement here is that someone couldn't think of an easy way to write a test or interview question and went with a supper low common denominator that everyone could understand.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)