Manipulating the records in ASP

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

if it is an integer you don't need the quotes.

Code:

---

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

---

Thanks a lot I shall try and let you know how it worked in few hours..
Thanks much!