An SSD from a well known manufacturer will last longer and be faster than any rotating hard drive. The controllers and firmware in the drive are designed to compensate for wear-out problems. Buy something from Intel, Samsung, OCZ or STEC and you will be just fine.
(I was a firmware engineer for an SSD company for 11.9 years. I don't have time right now to give a detailed answer. Just trust me. ;-) )
Alan
Technically they are supposed to last just as long as regular hard drives but again the problem is that no one really tested in a production environment. From what I hear (I may be wrong) but most people use the ssd essentially as a cache space and even in enterprises they do. This is what I suggest you do with the SSD so that if the drive does die, you don't lose your important data.