I once went for a campaign with all non combat PCs.
A Journalist, a Bus Driver, a future Plastic Surgeon and a Kindergarden Nanny became involved in an attack. At first they did not even know who fights whom, nor what is used in that battle.
Hehe- the Scorpion Tank rolling over a few cars and shattering a wall while cutting down the local Police left and right with its 'Autocannons' (only described what they saw, avoided any 'technical terms' like MG, AC5, ect) seemed to them like the hammer of god.
It was a fun yet unusual game of MW3rd ed. as there were few combat encounters and instead they used whatever skills they had. I remember that Nanny was a rather gifted diplomat...
Anyway- if you have chars without combat skills try to keep them out of battles. If they choose to fight let them but be not afraid to show them why it is a bad idea.
It can be an exciting campaign that encourages both players and GM to think outside the box.