Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
magmo
Aged Yak Warrior
558 Posts |
 Posted - 2014-09-09 : 14:04:33
|
| HiI need to search 30 columns for a search value based on LIKE '%stringtofind%'. I know I can use the search criteria like this...WHERE Column1 LIKE '%stringtofind%' OR Column2 LIKE '%stringtofind%' OR and so on, but is there a more elegant way? |
|
|
viggneshwar
Yak Posting Veteran
86 Posts |
|
|
magmo
Aged Yak Warrior
558 Posts |
Posted - 2015-01-09 : 05:34:34
|
| Thanks, excellent reply! |
 |
|
|
|
|
|
search multiple columns