请帮忙看一下这句SQL

[enjoyeagle]

初学，帮帮忙，谢谢！
if accute=1 then //accute表示是否模糊查询
OP="LIKE'"
else
OP="='"
end if
sqlstr="Select * from 表名 where 字段名"&OP&变量&"' and left(pubdate,4) between datefrom and dateto "

[pengdali]

if accute=1 then //accute表示是否模糊查询
OP="LIKE '%" & 变量 & "%'"
else
OP="='" & 变量 & "'"
end if

sqlstr="Select * from 表名 where 字段名 "&OP&" and left(pubdate,4) between datefrom and dateto "

[pengdali]

如果datefrom,dateto也是变量：

if accute=1 then //accute表示是否模糊查询
OP="LIKE '%" & 变量 & "%'"
else
OP="='" & 变量 & "'"
end if

sqlstr="Select * from 表名 where 字段名 "&OP&" and left(pubdate,4) between '" & datefrom & "' and '" & dateto & "'"

[txlicenhe]

if accute=1 then //accute表示是否模糊查询
OP="LIKE '"
else
OP="= '"
end if
sqlstr="Select * from 表名 where 字段名 " & OP & 变量 & "' and left(pubdate,4) between datefrom and dateto "

[lvltt]

if accute=1 then //accute表示是否模糊查询
OP="LIKE '"
else
OP="= '"
end if
sqlstr="Select * from 表名 where 字段名 "&OP&" and left(pubdate,4) between '" & datefrom & "' and '" & dateto & "'"

[fjw2002]

if accute=1 then //accute表示是否模糊查询
OP="LIKE '%" & 变量 & "%'"
else
OP="='" & 变量 & "'"
end if

sqlstr="Select * from 表名 where 字段名 "&OP&" and left(pubdate,4) between datefrom and dateto "

[gmlxf]

if accute=1 then //accute表示是否模糊查询
OP="LIKE '%" & 变量 & "%'"
else
OP="='" & 变量 & "'"
end if

sqlstr="Select * from 表名 where 字段名 " & OP & " and left(pubdate,4) between '" & datefrom & "' and '" & dateto "'"

[aierong]

什么
好像不是sql语句

[foow]

if accute=1 then //accute表示是否模糊查询
OP="LIKE '%" & 变量 & "%'"
else
OP="='" & 变量 & "'"
end if

sqlstr="Select * from 表名 where 字段名 "&OP&" and left(pubdate,4) between datefrom and dateto "

应该考虑多个变量和字段名的时候