>I have created remote views of some SQL-SERVER tables and this works fine. The problem I'm running into is that the tables on SQL-SERVER are case sensitive and VFP is taking a table name like GL_MYTABLE and changing it to Gl_mytable in the View Designer. So if I open a view in the view designer I need to change it back to all caps before running the query or it doesn't work. Does anyone know how to prevent VFP from doing this? TIA

You can edit the view with an alternative view editor-- eView is here in the files section.