请帮忙解析SQL字符串！

luoxin1213

CString strSql = "updata t_table set aa = bb";

请各位大侠帮帮忙，将它解析出来
CString a;
CString b;
CString c;
CString d;
CString e;
CString f;
显示为下：
a = "updata";
b = "t_table";
c = "set";
d = "aa";
e = "=";
f = "bb";

food0012

CStringT::Tokenize
//typedef CStringT< TCHAR, StrTraitATL< TCHAR > > CAtlString;
CAtlString str( "%First Second#Third" );
CAtlString resToken;
int curPos= 0;

resToken= str.Tokenize("% #",curPos);
while (resToken != "")
{
   printf("Resulting token: %s\n", resToken);
   resToken= str.Tokenize("% #",curPos);
};
-----------------------------
Resulting Token: First
Resulting Token: Second
Resulting Token: Third

三哥戴表

CString strSql = "updata t_table set aa = bb";
        CString a;
        CString b;
        CString c;
        CString d;
        CString e;
        CString f;
        int i = strSql.Find("");
        a = strSql.Left(i-1);

三哥戴表

CString strSql = "updata t_table set aa = bb";
        CString a;
        CString b;
        CString c;
        CString d;
        CString e;
        CString f;
        int i = strSql.Find("",0);--后面一个参数是从哪里开始找
        a = strSql.Left(i-1);
j=strSql.Find("",i);
b=strSql.Mid(i,j);

大概就这样吧/。。。