I am trying to change the heading in a table if a criteria is met like so

<table width="100%" align="center" border="4" cellspacing="0" cellpadding="2">
  <tr>
    <th>BR #</th>
 <%IF objPagingRS.Fields(1) <> O7 THEN %>
    Class is <%= objPagingRS.Fields(1) %>
    <th>LNER<br />
      No.</th>
    <th>1946 #</th>
    <th>Pre-<br />
      Group</th>

 <% ELSE %>
    <th>WD 7xxxx<br />
      No.</th>
    <th>BR WD</th>

  <% END IF %>
Blah Blah

My prob is although "Class is <%= objPagingRS.Fields(1) %>" returns O7 when I select those records from the database the If statement appears to have no result as if O7 had not been selected, ???

Can anyone help please

(!]

It looks like you code is treating O7 like a variable rather than a string, try <> "O7".

HTH,

Chris

Many thanks, you got it in one.

I really should have worked it out myself (sigh)

Roy
:)