I am having this problem with the
objRs.Fields. When I retrieve the record from SQL if the value is 9 I
have to change it to 0. This is not working - can any of you help me
point where exactly I am missing the logic.


If objRs.Fields ("CirusStatusIndicator") = "'9'" Then
SET objRs.Fields ("CirusStatusIndicator") = "'0'"
Response.Write "<TD align=left>" & objRs.Fields
("CirusStatusIndicator") & "</TD>"
Else
Response.Write "<TD align=left>" & objRs.Fields
("CirusStatusIndicator") & "</TD>"
End if

Thanks
Sri