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