I am getting an error with constructing a SQL statement in C++. I am using C++ BuilderI am wondering if the string class is doing something weird with the special characters. In particular, the SQL engine complains about the [ bracket
String SQL = "SELECT * FROM Study ORDER BY InternalPatientID, [Study Date/Time]";
The weird part is that this was legacy code that used to work but now does not.