Inserting spaces into TABLE creation

[Jose Luis Sogorb]

Is it possible to include spaces when you create a table sSql="CREATE TABLE Graph (Date TEXT, Hour NUMBER,Temp_ºC NUMBER)"; For instance: Temp ºC instead of Temp_ºC Thanks

[Paul Watson]

José Luis Sogorb wrote: sSql="CREATE TABLE Graph (Date TEXT, Hour NUMBER,Temp_ºC NUMBER)"; For instance: Temp ºC instead of Temp_ºC Yes, enclose the "invalid" table name with [ and ] e.g. sSql="CREATE TABLE Graph (Date TEXT, Hour NUMBER,**[Temp ºC]** NUMBER)"; Just also remember when you reference that table to put the [ and ] in. (You can use this technique for reserved table names as well, e.g. Order must be used as [Order].

Paul Watson
Bluegrass
Cape Town, South Africa

Ray Cassick wrote: Well I am not female, not gay and I am not Paul Watson