[求助]关于查询语句的问题(急!)
我用sql="select * from book where SiteNum like {fn concat('%',{fn concat('"& Request("site_num") &"','%')})} order by SiteNum" 按编号查询数据库book表中的信息,但怎样实现在一句查询语句实现按编号或按名称查询,查询语句该怎样写.
请大家帮忙,谢谢!!!
那如何将下面那句语句合并起来呢?
sql="select * from book where SiteNum like {fn concat('%',{fn concat('"& Request("site_num") &"','%')})} order by SiteNum"
sql="select * from book where SiteName like {fn concat('%',{fn concat('"& Request("site_name") &"','%')})} order by SiteNum"
我试了下,都有错