Full Text 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 2012 Forums

Transact-SQL (2012)

Full Text Search

Author

Topic

noamg
Posting Yak Master

215 Posts

Posted - 2013-03-10 : 10:45:35

I need to write the following query, but in FullText search

select *
from Users
where CharIndex( 'abc', FirstName ) > 0

many thanks

Noam Graizer

UnemployedInOz
Yak Posting Veteran

54 Posts

Posted - 2013-03-12 : 08:03:58

-- something like
select *
from Users
where Contains( FirstName,'abc' )

noamg
Posting Yak Master

215 Posts

Posted - 2013-03-12 : 09:03:46

Sorry, I means to '%abc%'. any thing which include 'abc'

Noam Graizer

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources