Safale 04 will generally make a sweeter, less attenuated beer with more fruity english yeast esters. 05 will make a crisper, drier, better attenuated beer with fewer esters.
Compare a bottle of Fullers ESB (similar yeast to 04) with a Sierra Nevada Pale Ale (same yeast as 05).