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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Simple problem searching TEXT field

Author  Topic  Mojo Starting Member 19 Posts Posted - 2001-07-19 : 15:38:04 I have a TEXT field (the field has normal text ranging from 1kb to 180kb in size) that I am trying to do a keyword search on. Here is my problem: If I search on the word "one" I will receive all instances of "one" including someone, bone, one etc... I need to just return only those records that have the word "one" in the TEXT field. I have tried using LIKE 'one%' and that returns no records when they do exist. The only way I can return records is if I use LIKE '%one%', which of course, gives me all occurances. I have recently moved from Access 2000 (where I was using a MEMO field) to SQL Server 2000 (I now use a TEXT field). I had the same problem in Access. Here is my SQL statement: Select title From TABLE Where contents LIKE 'one%' Does anyone have an idea why this does not work? Thanks, Joe