title: How Handle Null Values(In Columns) In Telerik RadGrid? (Replace With HTML)
body: <p>i have a BooundColumn in my telerik RadGrid like below :  </p>
  
  <pre><code>                    &lt;telerik:GridBoundColumn DataField="Status" FilterControlAltText="Filter Status column"
                          HeaderText="Status" SortExpression="Status" UniqueName="Status"
                          FilterImageToolTip="Filter"&gt;
                          &lt;HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" /&gt;
                          &lt;ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" /&gt;
                      &lt;/telerik:GridBoundColumn&gt;
  </code></pre>
  
  <p>Status Column in my sql server 2008 database can accept null values and RadGrid shows them with an empty string.<br>
  how can i replace these <code>Empty Strings</code> with a <code>Colorable Strings</code>?<br>
  mean replacement with something like this -> <code>&lt;span style='color: red;'&gt;Empty&lt;/span&gt;</code>
  i know i can convert that BoundColumn to TemplateColumn like this :  </p>
  
  <pre><code>                        &lt;telerik:GridTemplateColumn FilterControlAltText="Filter TemplateColumn_Status column"
                              HeaderText="Status" UniqueName="TemplateColumn_Status" FilterImageToolTip="Filter"
                              ReadOnly="False" Visible="False"&gt;
                              &lt;ItemTemplate&gt;
                                  &lt;asp:Label ID="lblStatusInsideGrd" runat="server" Font-Size="11px" Text='&lt;%# (bool)Convert.IsDBNull(Eval("Status")) ? "&lt;span class=\"lblInsideGrd\"&gt;Empty&lt;/span&gt;" : Eval("Status") %&gt;'&gt;&lt;/asp:Label&gt;
                              &lt;/ItemTemplate&gt;
                              &lt;HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" /&gt;
                              &lt;ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" /&gt;
                          &lt;/telerik:GridTemplateColumn&gt;
  </code></pre>
  
  <p>this replacement is a good idea and works great. but by doing that i lose RadGrid <code>Filering</code> on this column.<br>
  would you please showe me another way with keeping RadGrid Friltering?  </p>
  
  <p>thanks in advance</p>