Want to wordsearch a table

[JaybeeinTekTips]

Hi, I'd like to search an entire table for a term, rather like,

SELECT *
FROM [dbo].[tablename]
where columname like '%blade%'

Except the term could exist in ANY column of the table...

Cheers,

JB

 

[ptheriault]

Jay,
This would work for you

SELECT  *
FROM  [dbo].[tablename]
where columname like '%blade%'
or columname2 like '%blade%'
or columname2 like '%blade%'
or ... [COLOR=red]Repeat for each column[/color]

- Paul
- Database performance looks fine, it must be the Network!