难度较大的一个sql语句，请各路兄弟帮忙。

[sxsgssgs]

Xbiao=int(Xbiao)
Ybiao=int(Ybiao)
Rname=int(Rname)
MaxX=Xbiao+Rname
MinX=Xbiao-Rname
MaxY=Ybiao+Rname
MinY=Ybiao-Rname

set rs=server.createobject("ADODB.Recordset")

strSQL = "select * from object where Xbiao in("&MinX&","&MaxX&") and Ybiao in("&MinY&" ,"&MaxY&")"
'Response.Write strsql
'Response.end
rs.Open strSQL,conn,1,1

我想找出Xbiao在MinX和MaxX之间且Ybiao在MinY和MaxY之间的记录，请问我这种写法对吗？？？？急。。。。。

[sxsgssgs]

up

[sxsgssgs]

up

[sxsgssgs]

up

[pizixt]

strSQL="select * from object where ( Xbiao between "&MinX&" and "&MaxX&") and ( Ybiao between "&MinY&" and "&MaxY&")"

[baby21st]

MaxX=cint(Xbiao+Rname)
MinX=cint(Xbiao-Rname)
MaxY=cint(Ybiao+Rname)
MinY=cint(Ybiao-Rname)