I have an SQL query to carry out, but one of the column names has a space in it. I managed to get an SQL query to work in Java by putting the Column name in double quotes. This does not seem to work in MFC. My query is as follows:
m_strCmdText = _T("select top 100 * from tbl_persons where Surname LIKE '"+Surname+"' AND \"Given name\" LIKE '"+GivenName+"'");
My query works if I just use Surname. I have tried using single quotes, but that doesn't work either.