<%
'******************************
'函數：formatQueryStr(str)
'參數：str,SQL語句
'作者：阿里西西
'日期：2007/7/13
'描述：格式化sql中的like字符串
'示例：<%=formatQueryStr(str)%>
'******************************
functionformatQueryStr(str)
dimnstr
nstr=str
nstr=replace(nstr,chr(0),"")
nstr=replace(nstr,"'","''")
nstr=replace(nstr,"[","[[]")
nstr=replace(nstr,"%","[%]")
formatQueryStr=nstr
endfunction
%>