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 |
|
cplusplus
Aged Yak Warrior
567 Posts |
 Posted - 2013-05-03 : 12:04:54
|
| Is it possible to check in all rows and columns on a table for this string:'BSYRRVP'select * from AL_PARENT_CHILD Thanks for the helpful info. |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2013-05-03 : 12:30:08
|
| There might be even better ways of searching it but here it goes a possible one :) SELECT * from Table WHERE Col1+' '+Col2+' '+Col3+...' '+ColN Like '%BSYRRVP%'Note: Columns in Where conidtion should only be of string datatypes.CheersMIK |
 |
|
|
|
|
|
How to check in all rows and column of the table