Well I went to school for four years...
And where am I now? Writing in a message board from my deskjob!
I went to Columbia College Chicago for four years.
Columbia has a GREAT sound program, IMHO better than Full Sail and all the other tech schools. If you are thinking of real college and a real degree (Bachelor of Arts) then think Columbia: Real studios, real gear, real pros teaching EVERYTHING about audio.
From the physics of sound waves to live sound reinforcement to post-production sound for films to sound contacting to (everyone's fav) ProTools.
So, I took the classes, did an internship (work for free at a place you would normally never get hired at) and realized I have no interest in trying to make money off of recording. Really, it didn't seem like fun, it felt like work and I didn't dig it. What do I dig? Recording my own stuff or bands I know and like. And my college degree got me an office job that pays the bills with plenty of "me time".
Like the previous posters have said, the field is saturated, and you sure as heck won't find an ad in the classifieds. Schooling and whatever degree is associated with it is no guarantee. Some of it really is "who ya' know" or who gets to know you and hear your good work. Network! Meet people!
If you are thinking about college, take a look at Columbia, or else check out the tech schools.