SELECT @leftPV=SUM(TotalPv) FROM Com_Order WHERE OrderPeriod =@Duration AND MemNumber IN (SELECT MemNumber FROM dbo.Com_Member WHERE MemBinaryList LIKE ‘%,‘+CAST(@leftLeg AS NVARCHAR(256)) + ‘,%‘)
包含单引号的sql
原文：http://www.cnblogs.com/armanda/p/4839525.html
