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)
 Like pattern

Author  Topic 

gxs8938
Starting Member

23 Posts

Posted - 2010-04-27 : 01:20:07
Hello All,

what is the pattern in sql for matching somthing like below

If the search string is “some one” would match and of this set [‘some’, ‘one’, ‘some one’]

so basically if i search for "some one" query should return subjects named
1.'some'
2. 'one'
3. 'some one'

Regards,
Guru




tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-27 : 01:22:25
I think full-text indexing can do this. Have you looked into it?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -