Searching a column of 'text' datatype

[TomBarrand]

I have a column in a table that is the 'text' datatype. I would like to construct a query that would search this column for a value or values being present.

For example, I might want to seach the field for the word 'The'. In which case I would expect the query to return more results that if I searched for Manchester United.

What would the syntax be?

Thanks,

Tom

 

[tlbroadbent]

Use the Like predicate.

select * from table1
Where condition like '%the%'

select * from table1
Where condition like '%Manchester United%' Terry

;-) The single biggest challenge to learning SQL programming is unlearning procedural programming. -Joe Celko

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm