Thanks for the reply.
Worked out the solution myself, doesn't seem to be any clear samples about.
CDBVariant sVariant;
CString sProdName;
sections.Open(CRecordset::snapshot,SqlString);
sections.GetFieldValue(_T("Section text"),sVariant);
if (sVariant.dwtype == DBVT_ASTRING)
sProdName=(CString)*sVariant.m_pstringA;
Not the greatest solution either, due to the age and lack of support for C++ MFC nowadays, I moved to C#
char []desc=null;
char []test=null;
long len =
DbReader.GetChars(count, 0, test, 0, 65536);
DbReader.GetChars(count, 0, desc, 0, (int)len);
thedesc = new String(desc, 0, (int)len);
Hope this helps someone out :)