Fulltext search - SQL Server Forums

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)

Fulltext search

Author

Topic

ranganath
Posting Yak Master

209 Posts

Posted - 2008-07-10 : 03:14:53

hi all
this is the table

Declare @Table Table (Val varchar(1000))
Insert into @Table
Select 'Fax' Union All
Select 'Number' Union All
Select 'Test' Union All
Select 'axn' Union All
Select 'num' Union All
Select 'ber' union all
Select 'rte'

if we enter FaxNumberTest as input string then
the results should come if the val like 'Fax', 'Number', 'Test', 'Axn', 'ber', 'rte' and so on. how can i get this.

using full text indexes i can get this

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-07-10 : 05:20:53

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=106341

...you're apparently already asking this in the SQL2000 forum. which is it? 2k or 2k5?

Em

ranganath
Posting Yak Master

209 Posts

Posted - 2008-07-10 : 06:27:23

hi,

Iam Using Sql2005

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources