Let me start this post by saying if you are searching for the capability to do this, there is a very good chance you have problems with your current database architecture. Having said that, I realize you may not have the option of normalizing your database, and have no choice but to work with what you've got. If this is the case, you may find the following ......

---

With Dynamic SQL, one stored proc can do the work of many... Over the years, I have worked with a variety of different clients. It seems that every client has unique and different needs. In some situations, you may find that dynamic sql fills the void better than other solutions available to you. One scenario I have encountered in the past is one where ......

---

When you need the earlier of or later of two dates and NULL handling capability.

---

Add flexibility to your database with parsing functions.

---