By said:
Is the anti-virus sophos any good?
Yes
or the anti-virus clamwin?
It's very good at what it does, but I'm willing to bet it does not do what
you think. You don't want this one.
Which anti-virus is the best one, the one that would eliminate evey
virus or spyware in your computer?
None of them are _this_ perfect. AntiVirus and AntiSpyware products can be
compared to putting on a seatbelt when you get in your car. It doesn't
matter how good your seatbelt is or how many airbags are in your car
alongside it, it's still never ever going to be a good idea to go around
colliding with other cars. Your first defence against road accidents are
"safe driving" techniques.
Same with security software: You avoid viruses and spyware by using "safe
computing" techniques. If you fail to avoid them then you hope your virus
scanner and spyware remover can soften the impact of the blow.
For free products, look at AVAST or AVP, if this is for home use.
For pay-for products, look at Nod32 (home) or F-Secure (corporate).
These are not "the best one, the one that would eliminate every virus or
spyware" because that product literally does not exist despite what some
people claim, but I've personally used every product I've mentioned above
and had good results with each one.