Suri - I forgot to add - "and what Remi says...." <;-)

You should be able to do this with a case statement...

eg:"ORDER BY CASE @sort WHEN 'Col1' THEN Column1 WHEN 'Col2' THEN Column2 ELSE Column3 END"....or some such!

Far as I know - there does exist a vss/sql server integration for version control - seem to remember reading about it quite a few months back...maybe someone else can...

Erik - here's where I was hoping that someone who's actually used zip codes in an application would be able to help out with specific names/tools etc..

However, until then just...

Point taken Paul...however validations could still have been put in place to ensure this!

"XML is like violence...If it doesn't solve your problem, you are not using enough of it" -...

The developers should have put a validation check to begin with so this cleanup operation wouldn't have been needed...as Lowell said - the "not null" constraint should definitely be added...

There are so many areas of Sql Server that one may never get to use on the projects that the developers are working on....Replication, linked servers to name just a...

Erik - hopefully someone who's worked on something similar will respond to this soon, but here's my 2 cents..

Your best route would be to buy a "zip database" - something...

C'est le pays le plus peuplé au monde après la Chine - dead giveaway huh!!!

BTW - if you think of it as "sue" + "sheila" (some concatenation here...) it's easier!

If it's just one single user for one single table (how odd! maybe I don't understand correctly..) then the GUI is easy...

Otherwise I would create a role - grant/deny permissions...

Know what Remi - I think you should - maybe that's the only way you'll get people to respond!

ps: Maybe Frank will respond by morning...or Chris...or anyone else in European...

"Call a rose by any other name...." <;-)

Amazingly no one wants to pick up on the challege Remi - not even Ron!

As for "it's only the 3rd one I start. I can't understand how the other 1720+...

Dale - I wasn't really planning on coming back to this post and picking up the thread but I just finished reading the response to the "Ron Reagan" one...WHAT A...

Remi - point taken - though if you start out with a flawless design like I do (ya right!!!!!!) and never have to make schematic changes then this won't be...