title: SQLite, Filling in NULL with TEXT value
body: <p>I have a table with 2 columns and 9 Rows, FirstName and LastName.
  All rows of FirstName Column IS NOT NULL, but 1 row of LastName is NULL.</p>
  
  <p>How would I put a value into NULL?</p>
  
  <p>This is the Code I have:</p>
  
  <pre><code>SELECT Emp1.FirstName Employee, Emp2.FirstName Manager
  FROM Employee Emp1
  LEFT JOIN Employee Emp2 ON Emp2.EmployeeID = Emp1.ReportsTo;
  </code></pre>
  
  <p>Which produces:</p>
  
  <p><a href="https://i.stack.imgur.com/9LZlz.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9LZlz.jpg" alt="enter image description here"></a></p>
  
  <p>I have tried IFNULL, but it didn't seem to work.</p>
  
  <pre><code>SELECT Emp1.FirstName Employee, Emp2.FirstName Manager, IFNULL('No Manager')
  FROM Employee Emp1
  LEFT JOIN Employee Emp2 ON Emp2.EmployeeID = Emp1.ReportsTo;
  </code></pre>