SQL查询语句报错'2012' 附近有语法错误，请朋友们指点哪里错了呀？
declare @SQL VARCHAR(MAX)
DECLARE @Wherestring VARCHAR(MAX)
SET @Wherestring=' and a.CreateDate between ''2012-5-3 0:00:00'' and ''2012-5-3 23:59:59'' '


SET @SQL= ' SELECT
(case a.OperateType when ''aa'' then a.NewCardNo else '' end) as bb,a.OldCardNo as cc
FROM dbo.CardRevisionHistoryOfResetCard as a LEFT JOIN dbo.Organization as b on a.OID = b.OrganizationID
WHERE 1 = 1 '+@Wherestring+' UNION ALL '
SET @SQL=@SQL+' SELECT
(case a.OperateType when ''aa'' then a.NewCardNo else '' end) as bb,a.OldCardNo as cc
FROM dbo.CardRevisionHistoryOfResetCard as a
INNER JOIN CardInfo as c ON a.OldCardNo = c.CardNo or a.NewCardNo=c.CardNO LEFT JOIN dbo.Organization as b on a.OID = b.OrganizationID
WHERE 1 = 1 and c.IsLoss=0 and c.IsUntread=0 and c.CardTypeCode=1 '+@Wherestring+' '


消息 102，级别 15，状态 1，第 4 行
'2012' 附近有语法错误。


[解决办法]
CASE中为空需要''''不是''

SQL code

SET @SQL= ' SELECT   (case a.OperateType when ''aa'' then a.NewCardNo else '''' end) as bb,a.OldCardNo as cc   FROM dbo.CardRevisionHistoryOfResetCard as a LEFT JOIN dbo.Organization as b on a.OID = b.OrganizationID  WHERE 1 = 1 '+@Wherestring+' UNION ALL 'SET @SQL=@SQL+' SELECT   (case a.OperateType when ''aa'' then a.NewCardNo else '''' end) as bb,a.OldCardNo as cc   FROM dbo.CardRevisionHistoryOfResetCard as a INNER JOIN CardInfo as c ON a.OldCardNo = c.CardNo or a.NewCardNo=c.CardNO LEFT JOIN dbo.Organization as b on a.OID = b.OrganizationID  WHERE 1 = 1 and c.IsLoss=0 and c.IsUntread=0 and c.CardTypeCode=1 '+@Wherestring+' '
[解决办法]
else '' -> else ''''