Example 1:

SCRIPT
BEGIN
DECLARE MyString1 VARCHAR(50) DEFAULT 'NULL';
DECLARE MyString2 VARCHAR(50) DEFAULT 'TEST';
DECLARE Comp Bool DEFAULT false;           

SET LOG MESSAGE TO 'Comp: '+CAST(Comp AS VARCHAR);
SET LOG MESSAGE TO 'MyString1: '+MyString1; // << no output?
SET LOG MESSAGE TO 'MyString2: '+MyString2;

SET Comp = MyString1 <> MyString2;

SET LOG MESSAGE TO 'Comp: '+CAST(Comp AS VARCHAR); // << no output?
SET LOG MESSAGE TO 'MyString1: '+MyString1; // no output?
SET LOG MESSAGE TO 'MyString2: '+MyString2;
END

Example 2:


SCRIPT
BEGIN
 DECLARE MyString1 VARCHAR(50) DEFAULT 'NULL';
 DECLARE MyString2 VARCHAR(50) DEFAULT 'TEST';
 DECLARE Comp Bool DEFAULT false;
 SET Comp = MyString1 <> MyString2;
 RAISE ERROR CODE 10000 MESSAGE 'Comp Result: ' + CAST(Comp AS VARCHAR); // << No output created
END