Full Text Search is not Searching single digit or

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 2005 Forums

Transact-SQL (2005)

Full Text Search is not Searching single digit or

Author

Topic

arun_mathur_123
Starting Member

1 Post

Posted - 2009-06-25 : 00:43:08

Hi All,

I am using Full Text Search in SQL Server 2005.
My database structure is as follows
Column1 Column2 Column3
0406.10.00 - Fresh (unripened Or Uncured) Cheese $1.220/kg DC:$1.220/kg, less 5%
A full text index has been created and all the three columns have been included in the index. When I issue the following query it does not return me the above shown record.
select * from <tablename> where CONTAINS ( * , '5%');
Any ideas, what could be the reason? Any help appreciated.

Arun Mathur

saran_d28
Starting Member

36 Posts

Posted - 2009-06-25 : 01:57:06

Hi,

Dont use the percentage symbol in the search string
For Ex:

select * from <tablename> where CONTAINS ( * , '5');

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources