The problem with anti-virus software is that they cant detect what they don't know exists. And with virus, trojans, malware, and spyware all using everything from heuristics to root kits finding them isnt always easy.
Some people will swear by this anti-virus software of this other software...