No antivirus is perfect. No single product can detect all infections with malware.
I use Trend Micro's Internet Security (PC-cillin) and AFAIK, I have never had an infection as long as I keep updating it regularly. But that does not mean that it is perfect either. It is always possible that I may get infected with some malware that it does not recognise. It's the same with all anti-malwares.