SQL查询时，代码有有关问题，向诸位请问（附有代码）

SQL查询时，代码有问题，向诸位请教（附有代码）
我利用vc做了个程序，用ADO操作ACCESS数据库
写查询的时候，利用性别和年龄两个字段联合，代码如下：
strsql = "SELECT * FROM Users WHERE (性别 like '%"+m_sGender+"%')And (年龄 BETWEEN '%"+m_nAge1+"%' AND '%"+m_nAge2+"%') ";

编译时显示 '+' : 4 overloads have similar conversions
请问是该如何修改

------解决方案--------------------
strsql.Format(_T("SELECT * FROM Users WHERE (性别 like '%%%s%%') And (年龄 BETWEEN '%%%%d%%' AND '%%d%%')"),m_sGender,m_nAge1,m_nAge2);
------解决方案--------------------
CString strsql = _T("SELECT * FROM Users WHERE (性别 like \'%")+m_sGender+_T("%\')And (年龄 BETWEEN \'%")+m_nAge1+_T("%\' AND \'%")+m_nAge2+_T("%\') "); 
这个？？？？？
------解决方案--------------------
strsql.Format(_T("SELECT * FROM Users WHERE (性别 like '%%%s%%') And (年龄 BETWEEN %d AND %d)"),m_sGender,m_nAge1,m_nAge2);