Darn....I am sorry Gary, I failed to mention that I am using SQL server 6.5 still. That is why I am struggling with this task. I don't think...

the data in the column consists of numbers that are AT MOST 4 char long. If I were to convert all to varchar what command would I use. ...

I will do that. I have started doing some perf checking on some of the SQL aspects. Hopefully I can establish a trend. Thanks for the help...Hey...

Sounds like what I thought. how to I add and drop single fields from a table without disturbing any other data in that table. I will have to...

I tried that a week or so ago and it worked. Thanks for the follow-up anyway. Have a great day.

Kevin

Thanks For your continued Help.

The server was originally not in the list. I can ping the server from a command line using IP address

Thanks For your continued Help.

Now I can not even create a DSN that connects to another server without getting the following error message:

Connection failed:

SQLState: '01000'

SQL Server Error: 10060

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen (connect())

Connection...

My Network Libraries all use TCP/IP from the time I set up the DSN. There are not users connected to this machine since it is still in it's testing...