急需得到的答案！

[shenlong123]

基本内容如下：
《％
if spyd="on" then
sp="cmpp"
end if
if splt="on" then
sp="sgip"
end if
if spdx="on" then
sp="smgp"
end if％》

<td align="center" width="221"><font color="red"><%=rs("num")%></font></td>
<td align="center" width="222">点播条数总计</td>
<%
rs.close
if seek="jingque" then
strSql="select count(id) as num from "&sp&"_recvlog where ((SUBSTRING(recvtime, 1, 8) >='"&sendtime0&"' and SUBSTRING(recvtime, 1, 8) <='"&sendtime1&"') or SUBSTRING(recvtime, 1, 8) ='"&sendtime&"' ) and desttermid = '" &desttermid & "' and msgcontent = '" &msgcontent& "'"
else
strSql="select count(id) as num from "&sp&"_recvlog where ((SUBSTRING(recvtime, 1, 8) >='"&sendtime0&"' and SUBSTRING(recvtime, 1, 8) <='"&sendtime1&"') or SUBSTRING(recvtime, 1, 8) ='"&sendtime&"' ) and desttermid like '%" &desttermid & "%' and msgcontent like '" &msgcontent& "%'"
end if
set rs=conn.execute(strSql)
%>

我的问题是当sp="smgp"时，msgcontent 的记录前要加118，请问怎么去写这个判断
效果如下：
20060706214959 059523347900 1189116 PB
20060706215725 05942993665 1189116 p+a

[xiangbo1123]

这个你完全可以在显示的时候判断...
if sp="smgp" then
response.write "118"&rs("msgcontent ")
end if