First of all, stop with the multiple posts...this is the 3rd repeat post! I deleted one in the newbie forum that had no responses and merged the one from maya chat into this one in the members forum...your question belongs here.
As far as your question goes, like everyone else said...any compositing app (after effects, shake, digital fusion, combustion, etc) and probably most video software (ala premiere or final effects) could do it as well. I think the free ones out there are VideoMach and VirtualDub....not sure if they do text but you could google them and find out.
"Terminat Bora Diem, Terminal Auctor opus."