diffrent ways to replaceis null in sql server
/* deffrent ways to replace null in isnull() function case statement coalecse() function*/ SELECT Aliase_Name.Column_Name AS IS NULL(Aliase_Name.Column_Name, "Message") AS Column_Name FROM Left_Table_Name Aliase _Name JOIN_TYPE Right_Table _Name Aliase_Name ON Aliase_Name.Cloumn_Name [operation] Aliase_Name.Column_Name /*............*/ SELECT Aliase_Name.Column_Name AS Aliase_Name CASE WHEN ALiase_Name IS NULL THEN "Message" ELSE ALiase_Name.Column_Name END AS Aliase_Name FROM Left_Table_Name Aliase _Name JOIN_TYPE Right_Table _Name Aliase_Name ON Aliase_Name.Cloumn_Name [operation] Aliase_Name.Column_Name /*...........*/ SELECT Aliase_Name.Column_Name AS COALESCE (Aliase_Name.Column_Name, "Message") AS Column_Name FROM Left_Table_Name Aliase _Name JOIN_TYPE Right_Table _Name Aliase_Name ON Aliase_Name.Cloumn_Name [operation] Aliase_Name.Column_Name