[Vintious]

I've just converted my site over from Access to SQL Server (only on my computer, I haven't uploaded it to my site). Anyway, I have a few questions about running SQL Commands on an SQL Server.

1) I used to be able to run this portion of an SQL Statement ..."ORDER BY [Networth] DESC, [TotalLand] DESC, [Country Name]", however it seems SQL Server cannot order by a text field... how do I fix this?

2) I used to have an Autonumber field in Access. The Upsizing wizard correctly converted it to a int field with increment. However, sometimes I want to delete all the records and start the incrementing over. I used to copy and paste a "Structure Only" version of the table in Access to fix this, but how do I do it with an SQL Database?

Thanks in advance.

[Vintious]

I am so sorry I did not notice I posted this in the wrong forum. I will repost in the correct forum :O