I totally agree with Scott and Ryan.

The question was not written properly.

I also work a lot with SQLCMD variables and the given answer from this QotD is not correct.

VRR,

I Took the liberty to upgrade your script a bit...

HBREST

[font="Courier New]

-- 2009-11-21, HBREST, SQLSERVERCENTRAL

-- This script gives you an overview of the column_name, data_type, minimal/maximal length of the contents...

Chim Kalunta,

Full text index is nice.

Then you can use the 'CONTAIN' option in the WHERE clause.

See http://www.developer.com/db/article.php/3446891/Understanding-SQL-Server-Full-Text-Indexing.htm

or MS Sqlserver 2005 Books online articles.