LIKE谓词是用来检查字符或字段值是否与指定的模式(pattern)匹配。想使用这个LIKE谓词,不防先了解一下T-SQL通配符(wildcard) 。
演示:
SELECT
[
Location
]
,
[
ItemCode
]
,
[
CustomerID
]
,
[
Allocated
]
,
[
Allocatee
]
,
[
AllocateDate
]
,
[
Version
]
FROM
dbo.wipStocks
WHERE
[
Location
]
LIKE
'
3%
'
根据上面的SQL 执行,会返回所有[Location]以'3'开头的记录结果: