title: How to enforce NOT NULL in a view's computed column
body: <p>I want to alter a view as follows:</p>
  
  <pre><code>ALTER VIEW [dbo].[ViewOne] as  
  SELECT columnOne,  -- not null  
         columnTwo, --not null
        (convert(decimal(2,0), columnOne)) as columnThree -- I want this not to be NULL
  FROM DBOne.TableOne
  </code></pre>
  
  <p>Since columnOne is "not null" I want to force columnThree to be "not null" also.
  Is is possible, impossible, implicit, useless or could cause serious problems since columnOne is char(2) populated with algarisms only.</p>
  
  <p>I simply would like to know the syntax</p>