Unclosed quotation mark before the character string ') IS NULL) 错误!

[取昵称麻烦]

SQL ='SELECT *'#13#10+
'FROM tMoveForm A LEFT OUTER JOIN '#13#10+
' tMoveFormList B ON A.FormID = B.FormID LEFT OUTER JOIN '#13#10+
' bProduct C ON B.ProductID = C.ProductID'#13#10+
'WHERE A.FormDate BETWEEN :D1 AND :D2 AND (NOT NULLIF(A.Checker,'') IS NULL) ';
向朋友们请教,这条语句那里有问题报错信息"Unclosed quotation mark before the character string ') IS NULL) "

[hongqi162]

(NOT NULLIF(A.Checker,'') IS NULL

修改成

(NOT NULLIF(A.Checker,'''') IS NULL

[取昵称麻烦]

我试试，谢谢