Query name	VarChar Null and Empty Overlap
Server Asset Type	Job, Shared Container
Analysis Type	Advisory
Description	Server Jobs differentiating Null and empty strings which requires modifications to achieve in the Parallel engine.

Issue

Your Server Job uses features which differentiate Null and empty string but which are not available in the Parallel engine. You can find a deeper explanation at Differences between Server and Parallel VarChar.

Actions

This is an advisory Asset Query only, but you may choose to modify your Job(s) to use Parallel-native features and functions to achieve the differentiation you require.