如何用SELECT cbsysbarcode FROM rdrecords10 WHERE cbsysbarcode like '%(c.入库单号)%' 备注(c.入库单号):c表中的入库单号字段值为0000000026 nvchar查询SELECT cbsysbarcode FROM rdrecords10 WHERE cbsysbarcode like'%0000000026|%'一样的结果?
è¿ç§åµå¥æ¥è¯¢ï¼ç´æ¥ä½¿ç¨like å
sqlserveråµå¥æ¥è¯¢çä¸ç§æ¹æ³
WHERE exists(
select null from c where a.cbsysbarcode like '%'+c.å ¥åºåå·+'%'
)
请è¯ä¸è¯ï¼å¦æçé®ï¼åæ¶æ²éï¼
追é®ä¸ºä»ä¹æ¥è¯¢é£éå¯ä»¥ç¨nullï¼ç¨* 代æ¿ç»æä¸æ ·ã
温馨提示:答案为网友推荐,仅供参考