Thank this author by sharing:
Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, ...
Search for String Occurence with this script in your stored procedures.
search string help needed...
Searches precompiled procedures for the provided search string, optionally limiting to names matchin...
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.