Execute SQL Question

Question

If I have quotation marks for my SQL column names, what should I do when doing Execute SQL:

pmroz · Accepted Answer

Use the special escape characters \[ and ]\ to surround your string, then you can have as many double quotes as you want.

sql_statement = 
"\[SELECT TOP 1000 [Test Number]
	,[Test Type]
	,[Ton]
	,[Date]
	,["OD Unit  Model"]
	,["OD Unit  Serial"]
]";
write(sql_statement);

Here's what shows up in the log window:

SELECT TOP 1000 [Test Number]
	,[Test Type]
	,[Ton]
	,[Date]
	,["OD Unit  Model"]
	,["OD Unit  Serial"]