Sorry, disregard. I *thought* you said table name, but I see you wrote FIELD name.
Hi David,

It's because VFP does not allow a numeric first character as an ALIAS, so it assigns its own ALIAS to the table.

You can circumvent it by assigning your own (valid) ALIAS to the table, then use that ALIAS to SELECT it.

cheers

>Hi all,
>
>I noticed that although I can open a table with a field start with a digit, I cannot browse such table. The error is: "The data source for this object must be a variable reference."
>
>The table is a MSSQL table defined as:
>CREATE TABLE [TestTable] (
> [ID] [nvarchar] (10) NOT NULL ,
> [01] [int] NOT NULL DEFAULT (0)
>)
>
>The VFP code returning the error is:
>lnHandle = SQLCONNECT("an_odbc_dsn")
>SQLEXEC(lnHandle, 'select [01] from TestTable')
>BROWSE
>
>Is it just my problem or is it a known issue?
>
>TIA.