How can we help you today? How can we help you today?

Rule BP011 (A comparison or expression is using NULL without explicit provision for a NULL value.)

This rule is not appropriate for a CASE statement.

CASE [s2].[SchoolID]
WHEN NULL THEN .[SchoolNumber]
ELSE [s2].[SchoolNumber]
END AS [SchoolNumber]

Unless what you're saying is that .SchoolNumber could also be NULL?
BrienKing
0

Comments

1 comment

Sort by
  • Michael Clark
    Hi @BrienKing,

    Thanks for getting in touch.

    I'm having trouble parsing that query as " .[SchoolNumber]" is missing its alias.

    Would it be possible to paste the whole snippet?

    Best,
    Michael
    Michael Clark
    0

Add comment

Please sign in to leave a comment.