title: How to pass tSQL CONCAT string result to GridView BoundField Column?
body: <p>I'm trying to get a SQL string result from CONCAT to a GridView Column.
  Is there a way to grab <strong>fullName</strong> for a column DataField?</p>
  
  <p>Every answer I can find on the internet says to use a template field in asp.net.  What if I want to use a stored procedure?</p>
  
  <p>Perhaps I don't know correct terminology, but there is no answer to this on stackoverflow.</p>
  
  <pre><code>SELECT 
      CASE
         WHEN IsNull(Table.firstName, '') = ''
           THEN CONCAT(Table.lastName, ', ', Table.firstName) 
           ELSE Table.lastName
      END as **fullName**, 
      Table.website
  </code></pre>