Which collation in SQL Server 2008 most closely matches VFP? Filtering in the Where clause is case-sensitive in VFP, and so is sorting for the Order By clause, which my guess is in ASCII/ANSI order. These are not the default for SQL Server. SQL_Latin1_General_CP1_CS_AS appears the make filtering case sensitive, but not sort order. SQL_Latin1_General_CP437_BIN looks pretty close on the surface, but I'm wondering if anyone has found a better match. I want SQL query results to match existing VFP queries as closely as possible.

Also, I don't want the table/field names in SQL queries to be case-sensitive. Does that mean I need to set the collation for every column in SQL Server, or is there a better way?

Thanks.