SELECT * from biz_news WHERE texNS_Title LIKE ''
我想查询包含某个参数的所有新闻我是这样写的:
SELECT * from biz_news WHERE texNS_Title LIKE '*?*'
*是匹配0个或多个字符
?是ACCESS的参数求解,如果不能这么写应该怎么写?
PS:VS2005三层结构
我想查询包含某个参数的所有新闻我是这样写的:
SELECT * from biz_news WHERE texNS_Title LIKE '*?*'
*是匹配0个或多个字符
?是ACCESS的参数求解,如果不能这么写应该怎么写?
PS:VS2005三层结构
string sqlstr;
sqlstr="select * from biz_news where texNS_Title like '%"+参数+"%'";
VB这样写:
dim sqlstr as string
sqlstr="select * from biz_news where texNS_Title like '%"&参数&"%'"