I would be inclined to keep it in string format so as to not lose what may turn out to be important info in the future.

But one final concern:

If I...

OK Thanks for that, but how would I merge all the tables into a single table using SQL Server?

I wouldn't want to be stuck either at picking a town from a list of 10 000 names in a combo or listbox. I think you'd be better of...

OK, so what you are saying is that I should merge all of the 100 odd tables into one table? That would not be too difficult as the tables all...

Well thank for the offer, it is appreciated, obviosly I would not want to reveal excatly what I am trying to do before my site is launched, that would be...

Heh... understood. But, now that you've said that, it makes you also wonder if they're cognizant of the damage they could cause. If they don't know how to...

Thanks for the reply, that has reassured my confidence in using stored procedures.

On your response to number 2: when passing the table name into the procedure usng dynamic SQL,...

Gary Johnson, I see you work on zillow.com?

Good job with that. That is one of my favorite web applications, up there with Google Earth and wikipedia.

Keep up the good work,...

[Quote]

But if we just hand you the solution without your having tried to solve it youself, how much do you truely learn? That's why you were asked to show...

Thank you Kyle,

That was exactly what I needed, the "create table as" was not working, but "select into" worked perfect.

Ok I have got it:

CREATE TABLE new_table

AS (SELECT Distinct (fieldname) FROM (tableName));

So simple!

Yet it took me an hour of research on the internet, but it should only...

Ok i think i am almost there, I have just found out about the "Distinct" keyword, this allows me to show just the distinct values in an SQL statement:

Select Distinct...

Its done

There really are no "DDL statements" as such. I am building the database by importing a bunch of seperate excel tables into Access and then importing the access database into...

This is not a homework question, I am looking for the SQL Command to write this in an SQL statement. I know this is a simple question, that is why...