How about aliasing the field names.
CREATE SQL VIEW... AS
SELECT 1 as NewName1, 2 as NewName2,... N as NewNameN FROM...
>I need to access a SQL Server database which has some fields named:
>
>1
>2
>3
>4
>5
>6
>7
>8
>9
>
>
>No matter how I try to get to this data, I am unsuccessful. I am not very handy with SQL Server and need some help making a "View" of this data which VFP can access via either a Cursor Adapter or a remote view.
>
>Please help I am stumped.
>
>Glenn
Mark McCasland
Midlothian, TX USA