title: DB2 field value replacement
body: <p>I have a DB2 employee table with a column called "Name" - varchar. it is not a primary key. 'Space' is also considered valid value here. some fields under this column has just space.</p>
  
  <p>Now I need a query that fetches all the values in this employee table by replacing 'Space' with NULL or any other default value say 'NoName'.</p>
  
  <p>One idea I have got, is to truncate the values with LTRIM function in SELECT, which will result 'empty string' and if I could find some string operation function that returns NULL with 'empty string' as input, I can use IFNULL of COALESCE to replace the NULL with 'NoName' as a result.</p>
  
  <p>But I could not recall any such function. Can you help?
  Or is there any other way of accomplishing this ?</p>