SQL语句怎么使用ASP自定义函数

Sql = "SELECT cm_Source.*, cm_User.User_CoolName, cm_User.User_Address,cm_User.User_Photo,cm_User.User_id,cm_User.dengji, cm_SrcType.Type_name, cm_SrcChild.Child_name " & _
"FROM cm_SrcChild INNER JOIN (cm_SrcType INNER JOIN (cm_Source INNER JOIN cm_User ON cm_Source.Src_UserID = cm_User.User_ID) ON cm_SrcType.Type_id = cm_Source.Src_TypeID) ON cm_SrcChild.Child_id = cm_Source.Src_ChildID " & _
"WHERE cm_Source.Src_IsOver=False and Src_TypeID="& Session("_WTypeID")

下面拼接的时候是：SQL1 = Sql & " and Src_ID in(in AutoKey(S_Key))"

AutoKey(S_Key)的返回值是："Select * from cm_Source where Src_title like '%" & strKey & "%' or Src_Url like '%" & strKey & "%'" & strNew1 & strNew2

Response.Write(Sql1)看了下是：...WHERE cm_Source.Src_IsOver=False and Src_TypeID=1 and Src_ID in(in AutoKey(S_Key))

AutoKey(S_Key)没有用。。。

---

函数不衡团是这么写的 你局轿双引号引起来就是字符 用&符号啊
sql1=sql&"and Src_ID in ("&AutoKey(S_Key)&")"
AutoKey(S_Key)的返回值是："Select * from cm_Source where Src_title like '%"咐腊橘 & strKey & "%' or Src_Url like '%" & strKey & "%'" & strNew1 & strNew2
select id from 不是*

---