Add Wildcards to Advanced Search Stored Procedure

Total article views: 345 | Views in the last 30 days: 26

 Rate this |   Join the discussion |  Briefcase

I have found that I can add wildcard support to the Advanced Search Stored Procedure submitted by jgroseth (Posted: 07/02/2004) here:
http://www.sqlservercentral.com/scripts/contributions/1201.asp

by simply modifying "charindex( c.string," to "patindex('%' + c.string + '%'"

I did this to take varying whitespace into account since SQL server does not care about whitespace, for example
"INSERT INTO DATABASE_MYTABLE" could have any number of spaces between "INSERT", "INTO", and "DATABASE_MYTABLE", Without wildcards one would need to search for every stored procedure that contained these three words. With wildcards we can limit the search to the three words in sequence"
"INSERT %INTO %DATABASE_MYTABLE"

My change hardly justifies changing the credit for this great stored proceure, so I left the credits as they are.

Total article views: 345 | Views in the last 30 days: 26