模板
教程
环境
性能
功能
管理
模糊查詢
发表于：2007-06-07来源：作者：点击数：
标签：
開始包含
SELECT MV001 AS EXPR1, MV002 AS EXPR2, MV004, MV005, MV021, MV022
FROM dbo.CMSMV
WHERE (MV002 LIKE '林%')
ORDER BY MV002
結束包含
SELECT MV001 AS EXPR1, MV002 AS EXPR2, MV004, MV005, MV021, MV022
FROM dbo.CMSMV
WHERE (MV002 LIKE '%林')
ORDER BY MV002
包含
SELECT MV001 AS EXPR1, MV002 AS EXPR2, MV004, MV005, MV021, MV022
FROM dbo.CMSMV
WHERE (MV002 LIKE '%林%')
ORDER BY MV002
