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: 100948 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) A socialist is someone who will give you the shirt off *someone else's* back.

Jeff Moden SSC Guru Points: 1003863 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)