Replace NULL values in SQL

SELECT d.DepartmentID

       ,Name

       ,Budget

       ,StartDate

       ,Title

       ,Credits

  FROM Department d

  left join Course c  on c.DepartmentID=d.DepartmentID

DepartmentID	Name	Budget	StartDate	Title	Credits
1	Engineering	350000.00	2007-09-01 00:00:00.000	EEE	8
1	Engineering	350000.00	2007-09-01 00:00:00.000	ECE	7
1	Engineering	350000.00	2007-09-01 00:00:00.000	Civil	5
1	Engineering	350000.00	2007-09-01 00:00:00.000	CSE	6
1	Engineering	350000.00	2007-09-01 00:00:00.000	Mech	6
1	Engineering	350000.00	2007-09-01 00:00:00.000	IT	4
2	English	120000.00	2007-09-01 00:00:00.000	Composition	3
2	English	120000.00	2007-09-01 00:00:00.000	Poetry	2
2	English	120000.00	2007-09-01 00:00:00.000	Literature	5
3	Degree	135000.00	2007-09-01 00:00:00.000	NULL	NULL
4	Economics	200000.00	2007-09-01 00:00:00.000	Microeconomics	3
4	Economics	200000.00	2007-09-01 00:00:00.000	Macroeconomics	3
4	Economics	200000.00	2007-09-01 00:00:00.000	Quantitative	2
5	Doctor	335000.00	2007-09-01 00:00:00.000	NULL	NULL
6	Inter	100000.00	2007-09-01 00:00:00.000	NULL	NULL
7	Mathematics	250000.00	2007-09-01 00:00:00.000	Trigonometry	4
7	Mathematics	250000.00	2007-09-01 00:00:00.000	Maths	6
8	B.Sc	78200.00	2021-03-26 00:00:00.000	NULL	NULL

 

/* Using ISNULL function */

  SELECT d.DepartmentID

       ,Name

       ,Budget

       ,StartDate

       ,ISNULL(Title,'No Title') Title

       ,ISNULL(Credits,0) Credits

  FROM Department d

  left join Course c  on c.DepartmentID=d.DepartmentID

DepartmentID	Name	Budget	StartDate	Title	Credits
1	Engineering	350000.00	2007-09-01 00:00:00.000	EEE	8
1	Engineering	350000.00	2007-09-01 00:00:00.000	ECE	7
1	Engineering	350000.00	2007-09-01 00:00:00.000	Civil	5
1	Engineering	350000.00	2007-09-01 00:00:00.000	CSE	6
1	Engineering	350000.00	2007-09-01 00:00:00.000	Mech	6
1	Engineering	350000.00	2007-09-01 00:00:00.000	IT	4
2	English	120000.00	2007-09-01 00:00:00.000	Composition	3
2	English	120000.00	2007-09-01 00:00:00.000	Poetry	2
2	English	120000.00	2007-09-01 00:00:00.000	Literature	5
3	Degree	135000.00	2007-09-01 00:00:00.000	No Title	0
4	Economics	200000.00	2007-09-01 00:00:00.000	Microeconomics	3
4	Economics	200000.00	2007-09-01 00:00:00.000	Macroeconomics	3
4	Economics	200000.00	2007-09-01 00:00:00.000	Quantitative	2
5	Doctor	335000.00	2007-09-01 00:00:00.000	No Title	0
6	Inter	100000.00	2007-09-01 00:00:00.000	No Title	0
7	Mathematics	250000.00	2007-09-01 00:00:00.000	Trigonometry	4
7	Mathematics	250000.00	2007-09-01 00:00:00.000	Maths	6
8	B.Sc	78200.00	2021-03-26 00:00:00.000	No Title	0

 

/* Using CASE statement */

SELECT d.DepartmentID

       ,Name

       ,Budget

       ,StartDate

       ,CASE WHEN Title IS NULL THEN 'No Title'

             ELSE Title

       END Title

       ,CASE WHEN Credits IS NULL THEN 0

             ELSE Credits

       END Credits

  FROM Department d

  left join Course c  on c.DepartmentID=d.DepartmentID

 

DepartmentID	Name	Budget	StartDate	Title	Credits
1	Engineering	350000.00	2007-09-01 00:00:00.000	EEE	8
1	Engineering	350000.00	2007-09-01 00:00:00.000	ECE	7
1	Engineering	350000.00	2007-09-01 00:00:00.000	Civil	5
1	Engineering	350000.00	2007-09-01 00:00:00.000	CSE	6
1	Engineering	350000.00	2007-09-01 00:00:00.000	Mech	6
1	Engineering	350000.00	2007-09-01 00:00:00.000	IT	4
2	English	120000.00	2007-09-01 00:00:00.000	Composition	3
2	English	120000.00	2007-09-01 00:00:00.000	Poetry	2
2	English	120000.00	2007-09-01 00:00:00.000	Literature	5
3	Degree	135000.00	2007-09-01 00:00:00.000	No Title	0
4	Economics	200000.00	2007-09-01 00:00:00.000	Microeconomics	3
4	Economics	200000.00	2007-09-01 00:00:00.000	Macroeconomics	3
4	Economics	200000.00	2007-09-01 00:00:00.000	Quantitative	2
5	Doctor	335000.00	2007-09-01 00:00:00.000	No Title	0
6	Inter	100000.00	2007-09-01 00:00:00.000	No Title	0
7	Mathematics	250000.00	2007-09-01 00:00:00.000	Trigonometry	4
7	Mathematics	250000.00	2007-09-01 00:00:00.000	Maths	6
8	B.Sc	78200.00	2021-03-26 00:00:00.000	No Title	0