RE: Search a string from multiple column in a table

SSC Guru

Points: 59322

November 29, 2012 at 10:20 am

vikingDBA (11/29/2012)
Don't know if this is exactly what you are wanting, but I wrote this to search all tables for occurance of given string. ...

Don't you think it's a bit overkill to use it for searching string in three known columns of one known table...;-)

Actually, there few ways are available on inet to do the same:

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/the-ten-most-asked-sql-server-questions--1#2

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]