宁夏梅花井3,8块价格:asp截取问题?急!!

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/14 03:02:07
Sql= "Select * From User where SmallName like '%"&TypeID&"%'"
查找SmallName这个字段,这里面的数据是一个字符串,我想精确查找,就是把这个字符串分别输出来查找。
比如:
Sql= "Select * From User where SmallName ='"&TypeID&"'"

Sql= "Select * From User where SmallName(467,480,473,485)='"&TypeID&"'"(485)
怎么才能实现?

更精确一点的。
BigSQL= "Select * From user where f011='"&SmallName&"'"
这种最好。
反正是,越精确越好

特别特别的急!!!!
精确查找(467,480,473,485)这段字符串字符串
<a href="/Buyer/Small.asp?TypeID=<%=SmallRS("id")%>" class="Font_14"><%=SmallRS("f002")%></a> <Font class="s" color="#666666">(
<%Set SmallRs2= Server.CreateObject("ADODB.Recordset")
SmallSQL2= "Select * From DF_Support_Info where Patindex('%"&SmallRS("id")&"%',f011)<>0 and f001='卖' and check_kt=1"
'Response.Write(SmallSQL2)
'Response.End()
SmallRs2.Open SmallSQL2,adocon,1,1
SmallCount=SmallRs2.RecordCount
SmallRs2.Close
Set SmallRs2=nothing
Response.Write(SmallCount)%> )</Font></td>
<%
SmallRS.Movenext
Next
%>

楼主的意思表达的不是很明白