Common searches using search phrases, with options for 'all words', 'any words' or 'exact phrase'?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: GM (gmdevREMOVE_at_starband.net)
Date: 05/23/04 

Date: Sat, 22 May 2004 18:22:42 -0600

This must be a common question, but a day of research hasn't got me an
answer I can use.

How to do common searches using search phrases, with options for 'all
words', 'any word' or 'exact phrase'?

Is it best to just create the query in webpage code like VB.NET and execute
in on the database?

Or is there a way to send parameters to a stored procedure or something?

Does 'full-text search' offer a good solution?

I've looked at parameter arrays, but they seem to depend on joining
temporary tables and can't use 'like' type operators.

Dynamic SQL seems full of problems, especially security concerns.

Any suggestions to help get me further along?