Fix function bug in VS2008 c++

Here is the function __________________________________ CString CRDoc::GetChairNo(CString strAcctNum, CString strDepNum, CString strSequence) { CString strChairNo; TCHAR sql[300]; TCHAR temp[32]; void* val; SWORD type; int size; // [login to view URL] memset(temp, 0, sizeof(temp)); val = temp; size = sizeof(temp); type = SQL_C_CHAR; // [login to view URL] the patient email from resp table. // 2.1 Create the sql. memset(sql, 0, sizeof(sql)); sprintf_s(sql, sizeof(sql), "select first chair from [login to view URL] where acctnum='%s' and depnum='%s' and sequence in (%s) ", strAcctNum, strDepNum, strSequence); // 2.2 Execute the sql. CSCISet::GetSQLValues(sql, &val, &size, &type, 1); strChairNo = temp; return strChairNo; } ___________________________________________________________ Most times it return the correctly but sometimes it returns zero (which is incorrect) Need knowledge of VS2008 c++ and sql