title: sql server 2008 return value getting shortened when using ISNULL and NULLIF
body: <p>I have this select statement where I check whether phone number in null or empty and if they are then I would return 'No Phone Number is available'. Like this</p>
  
  <pre><code>SELECT 
        Name, 
        ISNULL(NULLIF(Phone, ''), 'No Phone Number is available') AS Phone
  FROM Person
  </code></pre>
  
  <p>But when the phone number is null or empty I am not getting the full text 'No phone number is available'. Only the first 20 characters is getting returned. The length of Phone field is also 20. So I think this is returning text depending on the length of the phone field.</p>
  
  <p>Is there a way to correct this without changing the field length?</p>