This looks like a cool way of handling this standard SQL need:
http://dotnetjunkies.com/WebLog/seichert/archive/2003/06/20/308.aspx
Another more in-depth discussion can be found at:
http://www.sommarskog.se/dyn-search.html