在程序中如何对数据库进行模糊查询

[aa12983]

CString aa;
m_Edit5.GetWindowText(aa);

CDatabase cd;
if (cd.IsOpen())
cd.Close();
cd.Open("my");
cd.ExecuteSQL(CString("select * from stu where name like '%%" + "aa%%'
or age like '%%" +"aa%' or number like '%%" + "aa%%' or sex like '%%"+"aa%%'"));

我写的查询的句子如上，但产生了如下错误，这个错误是什么意思呢，正确的要怎么写呢？谢谢了

--------------------Configuration: 1 - Win32 Debug--------------------
Compiling...
1View.cpp
D:\编程\c++\自编\mfc\项目\项目新\1\1View.cpp(309) : error C2110: cannot add two pointers
Error executing cl.exe.

[xhzxlqt]

意思是说char*!+char*
需要CString(char*)+CString(char*)

[aa12983]

那要怎么写呢

[xhzxlqt]

CString SQL,str;
str="%%"+aa+"%%";

SQL="select * from stu where name like " + str +
" or age like "+ str +
" or number like " + str +
" or sex like "+str;