Partly it's what lens to avoid for sure - some are better and worse than others. However, you can mitigate it in a couple of ways. First is to stop down. The other is to avoid really bright contrast where there's a lot of light coming through the lens. The CA is mostly visible on high contrast. I'm not enough of a lens geek to tell you which lenses are best, so I'm sure others will chime in there.
Graeme