查询报表：关键词条件查询物料编码

SELECT T0.[ItemCode], T0.[ItemName], T0.[FrgnName]
FROM OITM T0
WHERE (T0.[ItemCode] LIKE '%%[%1]%%'
		OR '[%1]' = '')
	AND (T0.[ItemName] LIKE '%%[%2]%%'
		OR '[%2]' = '')
	AND (T0.[FrgnName] LIKE '%%[%3]%%'
		OR '[%3]' = '')

五六零

海报 链接