Yes douglas.bentley, you can modify it according to your requirement. There are some wild card characters in sql server which can help you out with this.

Hello All,

Thanks for your comments and suggestions.

Also thanks Grasshopper for modifying the code.

I made a basic version for searching throughout the database and it can be extended as per...

Hello,

Thanks for the comment Martin.

Yes in case you are using it as a query then these checks need to be applied but if you are using as a proc(as I...